Re: FOREIGN KEY after CREATE TABLE? - Mailing list pgsql-hackers

From Peter Harvey
Subject Re: FOREIGN KEY after CREATE TABLE?
Date
Msg-id 3B883BE9.DB841EF2@codebydesign.com
Whole thread Raw
In response to FOREIGN KEY after CREATE TABLE?  (Peter Harvey <pharvey@codebydesign.com>)
List 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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: linking hba.c
Next
From: Bruce Momjian
Date:
Subject: Re: linking hba.c