Re: Uppercase to lowercase trigger?

From: björn lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Uppercase to lowercase trigger?
Date: 2012-05-15 06:04:47
Message-ID: 4362040.4665.1337061887660.JavaMail.geo-discussion-forums@vbym15
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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....

That way you don't need views or rewrite.

Do
create table foo( bar int);
Instead of
Create table
"foo" ("bar" int);

/björn lundin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2012-05-15 06:21:28 Re: Global Named Prepared Statements
Previous Message Tom Lane 2012-05-15 03:36:58 Re: Retrieving multiple columns from a subquery