Re: Create Foriegn Key - Mailing list pgsql-general

On Wed, 4 Jun 2003, David Busby wrote:

> List,
>     How can I create a Foriegn Key after my table is created?  I cannot find
> in docs (or google) anywhere.

See ALTER TABLE ADD CONSTRAINT, generally something of the form:

ALTER TABLE tablename ADD CONSTRAINT constraint name FOREIGN KEY(fkcol1)
 REFERENCES pktable(pkcol1);