pg_dump and quoting

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump and quoting
Date: 2000-10-03 17:55:46
Message-ID: Pine.LNX.4.21.0010031945350.969-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmx(dot)net http://yi.org/peter-e/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Randy Jonasz 2000-10-03 18:47:45 C++ client libs
Previous Message Lamar Owen 2000-10-03 17:21:21 Re: Syslog and pg_options (for RPMs)