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/