Re: [HACKERS] FOREIGN KEY after CREATE TABLE?

[Peter Harvey]

> > 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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl