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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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