Re: Accessing Specific Schemas - Mailing list pgsql-hackers

From Doug McNaught
Subject Re: Accessing Specific Schemas
Date
Msg-id 87k6xq2ji6.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Accessing Specific Schemas  ("Cason, Kenny" <kenny.cason@boeing.com>)
List pgsql-hackers
"Cason, Kenny" <kenny.cason@boeing.com> writes:

> 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 "."
>
> This error appears when I try to access ANY specific schema. Help!

Sounds like you're talking to an older server that doesn't understand
schemas.  What does "select version()" return?

-Doug


pgsql-hackers by date:

Previous
From: "Cason, Kenny"
Date:
Subject: Re: Accessing Specific Schemas
Next
From: Simon Riggs
Date:
Subject: Re: lock timeout patch