| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com> |
| Cc: | "Pgsql-General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DDL Exports w/ quotes? |
| Date: | 2001-11-26 15:09:52 |
| Message-ID: | 12571.1006787392@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-11-26 15:16:51 | Re: Problems with createdb in MacOsX.1 |
| Previous Message | kdebisschop | 2001-11-26 15:08:03 | Re: pl/perl won't build under 7.1.3 |