Re: FOREIGN KEY after CREATE TABLE?
Peter Harvey <pharvey@codebydesign.com>
From: Peter Harvey <pharvey@codebydesign.com>
To: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2001-08-25T23:59:37Z
Lists: pgsql-hackers
> > 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 ... > <Grr> I hate asking stupid questions. I scanned the ALTER TABLE syntax and somehow overlooked it. Thanks! Peter