Case insensitive primary keys

From: "Jeff Schnitzer" <jeff(at)infohazard(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Case insensitive primary keys
Date: 2001-03-13 00:45:44
Message-ID: 7E95297C88EDED4EB43BADD11871FA798C12@CHILL.haunt.infohazard.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello! I've got a question:

I'm trying to create a system with a string (varchar) primary key which
is *not* case sensitive. Is there any way I can create a primary key
column which automatically takes care of this?

I'm coming at this problem from a java app server, so my hands are
somewhat bound regarding the queries used to insert and search the
table. There are solutions, but the ideal (for me) would be for the
database to ignore the case of my key column. Is this possible?

Thanks,
Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Price 2001-03-13 00:56:30 pqReadData() - backend unexpectedly closed the channel
Previous Message Tom Lane 2001-03-13 00:23:52 Re: display temp table structure?