PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0.3.2-7) (1 row)
Hmmm... Makes me think I'm accessing the wrong version of PostgreSQL. Does that sound likely? -----Original Message----- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 1:19 PM To: Cason, Kenny Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] Accessing Specific Schemas 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
