Thread: 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