Re: DDL Exports w/ quotes? - Mailing list pgsql-general

From Tom Lane
Subject Re: DDL Exports w/ quotes?
Date
Msg-id 12571.1006787392@sss.pgh.pa.us
Whole thread Raw
In response to DDL Exports w/ quotes?  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [HOSTING QUESTION] - Advice on a decent PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Problems with createdb in MacOsX.1