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

On Thu, Jun 09, 2005 at 09:18:09 +0200, Andreas Kretschmer <akretschmer@despammed.com> 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.

Using a check constraint would be better a better way to do this.