On Thu, Jul 24, 2003 at 04:34:26PM -0700, Terence Chang wrote:
> All:
>
> I don't remember I even seen a document saying PostgreSQL are case
> sensitive. I just figure out that my column name are case
The docs have it in a footnote:
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-syntax.html#FTN.AEN1031
PostgreSQL's approach is backwards from the standard.
> sensitive. Is there any way that I can turn it off or force the
> object name to all upper case?
Yes. Double-quote them. Alternatively, _never_ double-quote and
just refer to everything in all upper case. Postgres will
automatically fold them to lower case anyway, but you won't get them
displayed in all upper case.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110