On Tue, Jun 28, 2011 at 04:00:42AM -0700, John R Pierce wrote: > capitals (probably reflecting its 1980s IBM origins), but PG decided > a long time ago to default to lower case, since the final result has > the same effect.
Well, it _sort of_ has the same effect. In a traditional SQL environment, if you use TABLENAME and "TABLENAME", they're equivalent, but tablename and "TABLENAME" are not. In PostgreSQL, that doesn't work: tablename and "tablename" are equivalent instead. This sometimes bites people when moving to Postgres, because their identifier quoting hasn't been consistent in their application. A -- Andrew Sullivan a...@anvilwalrusden.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
