Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Possible to set postgres in case insensitive mode ?
- From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
- To: Moe <mohamed5432154321(at)gmail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Possible to set postgres in case insensitive mode ?
- Date: Fri, 29 Jan 2010 19:44:03 -0700
- Message-id: <dcc563d11001291844x56704a8amdfdba43738c64ebb@mail.gmail.com> <text/plain>
On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote: > On Fri, Jan 29, 2010 at 2:52 PM, Moe <mohamed5432154321(at)gmail(dot)com> wrote: >> Is it possible to set postgres in case insensitive mode ? >> >> If so, how? > > What part, exactly, do you want to be case insensitive? I assume you > mean a text / varchar type? Look for citext, I believe it's a contrib > module, until 9.0 is out, which will include it natively. It's here: http://pgfoundry.org/projects/citext/ But it doesn't work in 8.3 or 8.4, only 8.2 and before. So either run that or wait for 9.0 I guess.
- References:
- Possible to set postgres in case insensitive mode ?
- From: Moe
- Re: Possible to set postgres in case insensitive mode ?
- From: Scott Marlowe
- Possible to set postgres in case insensitive mode ?
- Prev by Date: Re: Possible to set postgres in case insensitive mode ?
- Next by Date: Problem with 8.1's pg_dump -- not dumping a partition
- Previous by thread: Re: Possible to set postgres in case insensitive mode ?
- Next by thread: storing windows path strings
- Indexes: