On Tue, May 15, 2012 at 4:04 PM, björn lundin <b.f.lundin@xxxxxxxxx> wrote: > Hmm, I was under the impression that if you create the table with quoted field names, you get case-sensitive names, > But if you create the tables without quotes around the the field names, pg will make them lowercase, > But case-insensitive.... If they're quoted, case is retained; if they're not, they're lowercased. This rule applies to both creation and referencing, so if you always leave them unquoted, they are effectively case insensitive (technically they're case-folded), or if you always quote them, they're case sensitive. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
