pg_dump(all) --quote-all-identifiers - Mailing list pgsql-hackers

From Robert Haas
Subject pg_dump(all) --quote-all-identifiers
Date
Msg-id AANLkTikX-B6EWMDQExsxvtD7ZZcrKjXE12ZkVTexddam@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump(all) --quote-all-identifiers
Re: pg_dump(all) --quote-all-identifiers
List 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

pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Patch to show individual statement latencies in pgbench output
Next
From: Fujii Masao
Date:
Subject: Re: SR slaves and .pgpass