Postgres Pro
Downloads
Home   >   mailing lists

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

From Christof Glaser
Subject Re: FOREIGN KEY after CREATE TABLE?
Date
Msg-id 20010825233659.B604E12BE6@pinguin.gl.aser.de
Whole thread Raw
In response to FOREIGN KEY after CREATE TABLE?  (Peter Harvey <pharvey@codebydesign.com>)
List pgsql-hackers
Tree view 
On Sunday, 26. August 2001 00:37, Peter Harvey wrote:
> 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 ...

Regards,
-- 
Christof Glaser

pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: [PATCHES] Makefile.PL for Pg.so
Next
From: Tom Lane
Date:
Subject: Re: linking hba.c