Postgres Pro
Downloads
Home   >   mailing lists

Re: force varchar column to be lowercase - Mailing list pgsql-admin

From Andreas Wenk
Subject Re: force varchar column to be lowercase
Date
Msg-id 4A6ECFA7.30005@netzmeister-st-pauli.de
Whole thread Raw
In response to force varchar column to be lowercase  (Kevin Kempter <kevink@consistentstate.com>)
Responses Re: force varchar column to be lowercase
List pgsql-admin
Tree view 
Kevin Kempter schrieb:
> Can I use a check constraint, or something other than a function to force a
> column to be lowercase only?
>
>
> Thx in advance

try to use regexp in your CHECK CONSTRAINT:

CHECK (column::bpchar ~ '^[a-z]+$'::bpchar::text)

Cheers

Andy

pgsql-admin by date:

Previous
From: Albert Shih
Date:
Subject: WAL backup
Next
From: Greg Stark
Date:
Subject: Re: force varchar column to be lowercase