Re: SQL Server 2000 to PostgreSQL 8.0.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SQL Server 2000 to PostgreSQL 8.0.3
Дата
Msg-id 21462.1123640427@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: SQL Server 2000 to PostgreSQL 8.0.3  (Ben Kim <bkim@coe.tamu.edu>)
Ответы Re: SQL Server 2000 to PostgreSQL 8.0.3  ("josh@segrestfarms.com" <josh@segrestfarms.com>)
Список pgsql-admin
Ben Kim <bkim@coe.tamu.edu> writes:
>> In reviewing my tables, I found that for some strange reason a handful
>> of fields are not double-quoted.  Strange quirk:
>> ...

> In my case, DTS's "create" always wrapped the field names with double
> quote. The script seems to me not from DTS.

I think it's from pg_dump.  pg_dump (and most other PG-related tools)
will only quote names that need to be quoted per the PG rules ...
in other words, if it's all lower case, it does not need quotes.

            regards, tom lane

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

Предыдущее
От: FM
Дата:
Сообщение: problem during amrestore
Следующее
От: Tom Lane
Дата:
Сообщение: Re: problem during amrestore