Thread: DDL Exports w/ quotes?

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

"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