> In looking for how to do table constraints psql help says:
> software=> \h create table
> Command: create table
> Description: create a new table
> Syntax:
> CREATE TABLE class_name
> (attr1 type1 [DEFAULT expression] [NOT NULL], ...attrN)
> [INHERITS (class_name1, ...class_nameN)
> [[CONSTRAINT name] CHECK condition1, ...conditionN]]
This syntax help is out of date. The syntax for v6.4 (and perhaps
v6.3.2) became compatible with SQL92, except of course for the INHERITS
clause. That still must appear outside of the column-definition parens.
- Tom