"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
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 Fuhr||Date: 2005-01-17 19:56:09|
|Subject: Re: postgres Recover Deleted Data|
|Previous:||From: francyX||Date: 2005-01-17 16:28:00|
|Subject: help How i quit of list|