Case (in)-sensitivity & preserving case

From: pkubat(at)spamcop(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Case (in)-sensitivity & preserving case
Date: 2002-09-13 14:59:59
Message-ID: 1031929199.3d81fd6fdbc16@mail.spamcop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am looking for a means to preserve the case of tables, columns. I know that
I could quote the identifier, but then its case sensitive. I would like to
use: CREATE TABLE MyFooBar (LastName TEXT, FirstName TEXT); /dt Name | Type |
Owner
-------------------+-------+----------
MyFooBar | table | postgres

/d myfoobar
Attribute | Type | Modifier
-----------+---------+----------
LastName | text |
FirstName | text |
Is there a means to have postgres preserve the case for displaying and yet
have it case insensitive. Thanks Philip Kubat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-09-13 15:19:11 Re: [SQL] Latitude / Longitude
Previous Message Alvaro Herrera 2002-09-13 14:57:39 Re: Query having issues...