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