Case sensitivity

From: brichard(at)cafod(dot)org(dot)uk (Bruce Richardson)
To: pgsql-general(at)postgresql(dot)org
Subject: Case sensitivity
Date: 2001-02-27 05:47:12
Message-ID: 20010227054712.A13552@usb.cafod.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Leslie 2001-02-27 06:32:06 Re: Correct behaviour of "DROP DATABASE"
Previous Message Tom Lane 2001-02-27 04:06:03 Re: corrupted pg_xlog/0000000000000000