Re: FOREIGN KEY after CREATE TABLE?

From: Peter Harvey <pharvey(at)codebydesign(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FOREIGN KEY after CREATE TABLE?
Date: 2001-08-25 23:59:37
Message-ID: 3B883BE9.DB841EF2@codebydesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2001-08-26 00:18:55 Re: [PATCHES] Makefile.PL for Pg.so
Previous Message Christof Glaser 2001-08-25 23:36:58 Re: FOREIGN KEY after CREATE TABLE?