constraining chars for all cols of a table

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: constraining chars for all cols of a table
Date: 2011-02-18 21:23:51
Message-ID: 482E80323A35A54498B8B70FF2B879800482827264@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

I have to constrain the chars used for table columns. For example...
create table foo (col1 text, col2 text, col3 text);
... where
col1 has to be all uppercase, nothing but [A-Z]
col2 has to be all lowercase [a-z] plus [0-9] is also allowed
col3 can be mixed case plus [0-9] and sqr brackets (but nothing else).

I could put a check constraint on each/every table column, but that seems complicated and potentially slow.

I could do this check using the existing insert and update before triggers, but then I'd have to loop through all the columns and decide one by one how to
check them. Again, slow and complicated.

Is there a better way? Whatever I do, I'd have to be able to capture violations to provide informative feedback to the users through the perl script that'll actually be doing the insert/update.

Thanks in Advance !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2011-02-18 21:31:45 Re: Canceling a DELETE query
Previous Message Chris Browne 2011-02-18 20:07:41 Re: disable triggers using psql