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