Re: [despammed] rejecting characters in a field - Mailing list pgsql-sql

On Jun 9, 2005, at 4:18 PM, Andreas Kretschmer wrote:

> am  09.06.2005, um 12:36:31 +0530 mailte Kenneth Gonsalves folgendes:
>
>> hi
>> i have a table with a varchar field called 'name'. I want postgres to
>> reject any insert with characters defined as illegal characters, for
>> example '*/^#'. How do i do this?
>>
>
> With a RULE or a TRIGGER.

Or a CHECK constraint on the column.

Michael Glaesemann
grzm myrealbox com