Обсуждение: Case (in)-sensitivity & preserving case

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

On Fri, Sep 13, 2002 at 10:59:59AM -0400, pkubat@spamcop.net wrote:
> I am looking for a means to preserve the case of tables, columns.

Use double quotes.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110