"Campano, Troy" <Troy.Campano@LibertyMutual.com> writes:
> Whenever I use pg_dump, pgadmin2, or phpPgAdmin and I try to export the DDL
> and/or data from a PostgreSQL database, it always puts " (double quotes)
> around the table and column names. Does anyone have any ideas why? Do you
> know how to stop it from doing this??
pg_dump -n. Dunno about the others.
The reason pg_dump does it is to protect names that might have become
reserved words in a later version of Postgres.
regards, tom lane