Case insensitive primary keys - Mailing list pgsql-general

From Jeff Schnitzer
Subject Case insensitive primary keys
Date
Msg-id 7E95297C88EDED4EB43BADD11871FA798C12@CHILL.haunt.infohazard.org
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: display temp table structure?
Next
From: "Thomas F. O'Connell"
Date:
Subject: infinity