DDL Exports w/ quotes?

Started by Campano, Troyover 24 years ago2 messagesgeneral
Jump to latest
#1Campano, Troy
Troy.Campano@LibertyMutual.com

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??

Thanks!

Troy Campano

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Campano, Troy (#1)
Re: DDL Exports w/ quotes?

"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