Re: Accessing Specific Schemas

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Accessing Specific Schemas
Date: 2004-06-29 20:19:05
Message-ID: 20040629201905.GB22115@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Cason, Kenny 2004-06-29 20:24:05 Re: Accessing Specific Schemas
Previous Message Alvaro Herrera 2004-06-29 20:17:56 Re: nested xacts and phantom Xids