Re: Accessing Specific Schemas

PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0.3.2-7)
(1 row)


Hmmm... Makes me think I'm accessing the wrong version of PostgreSQL. Does that sound likely?

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@dcc.uchile.cl]
Sent: Tuesday, June 29, 2004 1:19 PM
To: Cason, Kenny
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Accessing Specific Schemas


On Tue, Jun 29, 2004 at 12:07:30PM -0700, Cason, Kenny wrote:
> I'm having trouble accessing specific schemas and wonder if maybe I
> haven't installed something properly in 7.4.2. Here is what is
> happening:
>
> SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
>
> ERROR:  parser: parse error at or near "."

Looks like your server doesn't have schema support at all ... what does "select version()" give you?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
www.google.com: interfaz de línea de comando para la web.