Horton

Re: FOREIGN KEY after CREATE TABLE?

Christof Glaser <scivi@web.de>

View thread
From: Christof Glaser <scivi@web.de>
To: Peter Harvey <pharvey@codebydesign.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2001-08-25T23:36:58Z
Lists: pgsql-hackers 
On Sunday, 26. August 2001 00:37, Peter Harvey wrote:
> How can i add foreign keys after the CREATE TABLE? Is there some
> combination of other SQL commands that will do the trick?

Peter,

try ALTER TABLE a_table ADD CONSTRAINT ... FOREIGN KEY ...

Regards,
-- 
Christof Glaser