Case (in)-sensitivity & preserving case - Mailing list pgsql-general

From pkubat@spamcop.net
Subject Case (in)-sensitivity & preserving case
Date
Msg-id 1031929199.3d81fd6fdbc16@mail.spamcop.net
Whole thread Raw
Responses Re: Case (in)-sensitivity & preserving case  (Andrew Sullivan <andrew@libertyrms.info>)
List 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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query having issues...
Next
From: Jan Wieck
Date:
Subject: Re: [SQL] Latitude / Longitude