Home > mailing lists

Re: Create Foriegn Key - Mailing list pgsql-general

From	Jeff Fitzmyers
Subject	Re: Create Foriegn Key
Date	June 9, 2003 08:00:06
Msg-id	78AA7595-9894-11D7-90DE-000A959C6000@cloverpub.com Whole thread Raw
In response to	Create Foriegn Key ("David Busby" <busby@pnts.com>)
List	pgsql-general

Tree view

ALTER TABLE "foreign_table_name" ADD CONSTRAINT "fkey_name" FOREIGN KEY 
("fkey_column") REFERENCES "primary_table_name"("primary_key_column_name
") ON UPDATE CASCADE ON DELETE CASCADE

(I think :-)

http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=r22871%2ehtm
http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x13546.htm

Have fun, Jeff

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

pgsql-general by date:

From: Stephan Szabo
Date: 09 June 2003, 07:48:06
Subject: Re: Create Foriegn Key

From: Ron Johnson
Date: 09 June 2003, 08:15:40
Subject: Re: Linux 2.6 kernel, tuned for use with databases -

Re: Create Foriegn Key - Mailing list pgsql-general

Previous

Next