From: | Chris Angelico <rosuav(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Uppercase to lowercase trigger? |
Date: | 2012-05-15 07:57:00 |
Message-ID: | CAPTjJmrUubX_q0HCXqM9UPrtRYF2MW4vMG8AS1OSKNB7Py_rnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 15, 2012 at 4:04 PM, björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Sumit Raja | 2012-05-15 08:01:28 | Re: Postgres 9.0 Streaming Replication and Load Balancing? |
Previous Message | chinnaobi | 2012-05-15 07:45:55 | HotStandby --Advice needed |