Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group