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

Accessing Specific Schemas

From: "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Accessing Specific Schemas
Date: 2004-06-29 19:07:30
Message-ID: B96DB973FD58EE469E4426886240EE9701E58B2B@xch-nw-03.nw.nos.boeing.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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!

Kenny Cason
The Boeing Company
Kenny(dot)cason(at)boeing(dot)com

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-06-29 19:22:52
Subject: Re: nested xacts and phantom Xids
Previous:From: Darko PrenosilDate: 2004-06-29 19:04:26
Subject: Re: INSERT rule

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