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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-01-17 19:56:09 | Re: postgres Recover Deleted Data |
Previous Message | francyX | 2005-01-17 16:28:00 | help How i quit of list |