pg_dump(all) --quote-all-identifiers

Robert Haas <robertmhaas@gmail.com>

View thread

From: Robert Haas <robertmhaas@gmail.com>

To: pgsql-hackers@postgresql.org

Cc: Hartmut Goebel <h.goebel@goebel-consult.de>

Date: 2010-06-14T00:35:08Z

Lists: pgsql-hackers

Attachments

quote_all_identifiers.patch (application/octet-stream) patch

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