Home > mailing lists

RE: Foreign key - Mailing list pgsql-general

From	Ben Souther
Subject	RE: Foreign key
Date	October 28, 2000 01:48:22
Msg-id	00ed01c0405a$91a38160$0264000a@redtrainint.com Whole thread Raw
In response to	Foreign key ("Patrick Welche" <prlw1@newn.cam.ac.uk>)
List	pgsql-general

Never mind......found it.

ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (col_name) REFERENCES table_name(col_name) MATCH FULL

From: "Ben Souther"
Date: 28 October 2000, 01:37:12
Subject: Foreign keys, adding to table.

From: "elein"
Date: 28 October 2000, 01:53:31
Subject: FW: Another array question: Join on array elements