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

Поиск
Список
Период
Сортировка
От J.F. Oster
Тема Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Дата
Msg-id 1728555082.20140602213442@mail.ru
обсуждение исходный текст
Ответ на Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  (Rob Richardson <RDRichardson@rad-con.com>)
Ответы Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  (David G Johnston <david.g.johnston@gmail.com>)
Список pgadmin-support
Hi Rob,

Monday, June 2, 2014, 4:43:01 PM, you wrote:

RR> I am not using plain SQL entered manually.═ I am using
RR> PGAdmin's table creation tool.

I'm sure that last week you provided table name in mixed case (more
precisely, with at least one character not in [_a-z0-9]). PgAdmin saw
that and wrapped it in double quotes. If all the letters are
lowercase, no double quotes are added.
By the way, this relates to any identifiers, not only table names.
Isn't that mentioned in PgAdmin help?.. If not, it probably should.

-- 
Best regards,J.F.




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

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