the web documentation (and possibly the source from whatever it is
generated) for sql-createtable (URL:
http://www.postgresql.org/idocs/index.php?sql-createtable.html) appears to
have a problem.
The description of foreign key mentions that:
" The FOREIGN KEY table constraint is similar to that for column
constraints, with the additional capability of encompassing multiple
Refer to the section on the FOREIGN KEY column constraint for more
but there isnt any foreign key column constraint. At least I couldn't find
I've also added a docnote at the bottom of the web page with a link to
someone (not me !) who has written an example on foreign key usage, in case
someone else needs it.
Hope that helps,