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

Re: SQL syntax

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gary(dot)Broadbent(at)gtnet(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SQL syntax
Date: 2005-01-17 18:22:40
Message-ID: 4177.1105986160@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Gary Broadbent" <Gary(dot)Broadbent(at)gtnet(dot)com> writes:
> I then tried to do a select:
> SELECT * FROM CITIES;
> and this did not work. However when I tried
> SELECT * FROM "GTX"."CITIES";
> my select statement DID work.

> Why are do my select statements work with quotes surrounding the schema and
> table although the help does not say that quotes are required?

Apparently you created the table with all-upper-case not all-lower-case
name.  See 
http://developer.postgresql.org/docs/postgres/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
particularly the last paragraph of that section.

			regards, tom lane

In response to

  • SQL syntax at 2005-01-17 14:05:02 from Gary Broadbent

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-01-17 19:56:09
Subject: Re: postgres Recover Deleted Data
Previous:From: francyXDate: 2005-01-17 16:28:00
Subject: help How i quit of list

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