Ben Kim <bkim@xxxxxxxxxxxx> 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
