Re: SQL syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL syntax
Дата
Msg-id 4177.1105986160@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SQL syntax  ("Gary Broadbent" <Gary.Broadbent@gtnet.com>)
Список pgsql-admin
"Gary Broadbent" <Gary.Broadbent@gtnet.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Gary Broadbent"
Дата:
Сообщение: SQL syntax
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: postgres Recover Deleted Data