Case Insensitive Database

This is a multi-part message in MIME format.

------_=_NextPart_001_01CB43BC.8FE08B82
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I currently have a mysql database that is case insensitive. Is it
possible to set up a case insensitive database in PostgressQl? So far
it doesn't look like it. And if it is possible what are the variables I
need to set?=20

Thanks

=20

Pam Ozer






------_=_NextPart_001_01CB43BC.8FE08B82
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Case Insensitive Database

On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam wrote:
> I currently have a mysql database that is case insensitive.=A0 Is it poss=
ible
> to set up a case insensitive database in PostgressQl?=A0 So far it doesn=
=92t
> look like it.=A0 And if it is possible what are the variables I need to s=
et?

You can use the contrib module for citext types.

--=20
To understand recursion, one must first understand recursion.

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin