Ben Kim <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
