On 23/09/2009 11:23, 纪晓曦 wrote: > I want detail usage introduction about constraint,such as how to > constrain a string to be exactly 4 character and start with 'z'. > Where can I find the reference of CHECK? detail usage. Try the documentation, presumably under CREATE TABLE: http://www.postgresql.org/docs Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general