Postgresql

This is an old revision of the document!

PostgreSQL Check Constraint Supports Regular Expressions

 CREATE TABLE example_table (
      first_name VARCHAR(100)
          CONSTRAINT check_first_name
         ( first_name ~* '^[a-z]+$')
 );

see: this