| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de> |
| Subject: | pg_dump(all) --quote-all-identifiers |
| Date: | 2010-06-14 00:35:08 |
| Message-ID: | AANLkTikX-B6EWMDQExsxvtD7ZZcrKjXE12ZkVTexddam@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
In response to a complaint from Hartmut Goebel:
http://archives.postgresql.org/pgsql-bugs/2010-06/msg00018.php
And per a design proposed by Tom Lane:
http://archives.postgresql.org/pgsql-bugs/2010-06/msg00211.php
PFA a patch to implement $SUBJECT. One interesting aspect of this
patch is that types like "integer" and "double precision" don't get
quoted in the output, whereas types like "text" do. But it turns out
that types like "integer" and "double precision" don't *work* if
they're quoted, so this is not a bad thing. It might possibly be
judged to require documentation somewhere, however.
Suggestions welcome.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| quote_all_identifiers.patch | application/octet-stream | 5.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2010-06-14 02:56:15 | Re: SR slaves and .pgpass |
| Previous Message | Greg Smith | 2010-06-14 00:22:36 | Re: Patch to show individual statement latencies in pgbench output |