Re: SQL Server 2000 to PostgreSQL 8.0.3 - Mailing list pgsql-admin

From Tom Lane
Subject Re: SQL Server 2000 to PostgreSQL 8.0.3
Date
Msg-id 21462.1123640427@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL Server 2000 to PostgreSQL 8.0.3  (Ben Kim <bkim@coe.tamu.edu>)
Responses Re: SQL Server 2000 to PostgreSQL 8.0.3  ("josh@segrestfarms.com" <josh@segrestfarms.com>)
List 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 by date:

Previous
From: FM
Date:
Subject: problem during amrestore
Next
From: Tom Lane
Date:
Subject: Re: problem during amrestore