adding column constraint

Timothy H. Keitt <keitt@nceas.ucsb.edu>

From: "Timothy H. Keitt" <keitt@nceas.ucsb.edu>
To: pgsql-general@postgresql.org
Date: 2000-07-26T19:57:33Z
Lists: pgsql-general
Can someone give an example of how to add a foreign key constraint to an
existing table?  (Pgsql and the man page differ and neither syntax seems
to work.)

I've tried:

alter table mytable add constraint col foreign key references reftable

with no luck.

Tim

-- 
Timothy H. Keitt
National Center for Ecological Analysis and Synthesis
735 State Street, Suite 300, Santa Barbara, CA 93101
Phone: 805-892-2519, FAX: 805-892-2510
http://www.nceas.ucsb.edu/~keitt/