Re: Accessing Specific Schemas - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Accessing Specific Schemas
Date
Msg-id 20040629201905.GB22115@dcc.uchile.cl
Whole thread Raw
In response to Accessing Specific Schemas  ("Cason, Kenny" <kenny.cason@boeing.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: lock timeout patch
Next
From: Peter Eisentraut
Date:
Subject: Default libpq service