Case sensitivity - Mailing list pgsql-general

From brichard@cafod.org.uk (Bruce Richardson)
Subject Case sensitivity
Date
Msg-id 20010227054712.A13552@usb.cafod.org.uk
Whole thread Raw
Responses Re: Case sensitivity  (Joel Burton <jburton@scw.org>)
Re: Case sensitivity  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-general
Discovering that text fields in Postgres are case sensitive - so "Text"
<> "text" and both can go into the same UNIQUE column - threw me a bit,
as this is different from other databases I've worked with.

Is there a toggle to turn off case sensitivity, either for a whole
database or for a column?  Or do I just have to get used to ~*?

--
Bruce

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: corrupted pg_xlog/0000000000000000
Next
From: Ben Leslie
Date:
Subject: Re: Correct behaviour of "DROP DATABASE"