I think that pg_dump should not quote identifiers that only contain
lower-case letters and underscores.  That will make it easier to move
dumps to other database products, because PostgreSQL is off the spec in
matters case folding in identifiers.  But it's just an idea; if the
performance hit would be too high, forget it.

(If you do this, then be careful about locale issues regarding what a
lower-case letter is.  Better to restrict it to ASCII perhaps.)

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Tue, 3 Oct 2000 19:55:46 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
pg_dump and quoting
At 19:55 3/10/00 +0200, Peter Eisentraut wrote:
>I think that pg_dump should not quote identifiers that only contain
>lower-case letters and underscores.  That will make it easier to move
>dumps to other database products, because PostgreSQL is off the spec in
>matters case folding in identifiers.  But it's just an idea; if the
>performance hit would be too high, forget it.

In something like pg_dump, I don't really think performance when dumping
metadata is an issue when you consider the cost of dumping actual data.

But to deal with the quoting issue, have you tried '-n' - I think it
basically turns off non-essential quoting.



----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Wed, 04 Oct 2000 21:05:58 +1000
Philip Warner <pjw@rhyme.com.au>
Re: pg_dump and quoting