Re: SQL Server 2000 to PostgreSQL 8.0.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Kim <bkim(at)coe(dot)tamu(dot)edu>
Cc: "josh(at)segrestfarms(dot)com" <josh(at)segrestfarms(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: SQL Server 2000 to PostgreSQL 8.0.3
Date: 2005-08-10 02:20:27
Message-ID: 21462.1123640427@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ben Kim <bkim(at)coe(dot)tamu(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-08-10 02:27:57 Re: problem during amrestore
Previous Message FM 2005-08-09 21:17:25 problem during amrestore