Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Дата
Msg-id CAKFQuwZ2rgMo+_4Sixv1FrxRoLvQnb=OFFZmrzhcHhgXbfLsBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  ("J.F. Oster" <jinfroster@mail.ru>)
Ответы Re: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
Дерево обсуждения

​I​
f all the letters are lowercase, no double quotes are added. 

​I don't know if this statement is actually true but it makes no difference in reality whether the double-quotes are added in the case where only lowercase letters and numbers/underscore are used.  As far the executor is concerned the same exact identifier text will be used.  Likely, and for reasoning purposes, it is sufficient to consider that ALL identifiers generated by pgAdmin are surrounded with double-quotes in the resultant SQL statements that are sent to the server.

​David J.


View this message in context: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

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

Предыдущее
От: Darren Duncan
Дата:
Сообщение: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Следующее
От: Dave Page
Дата:
Сообщение: Re: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name