Re: FOREIGN KEY after CREATE TABLE?

From: Christof Glaser <scivi(at)web(dot)de>
To: Peter Harvey <pharvey(at)codebydesign(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: FOREIGN KEY after CREATE TABLE?
Date: 2001-08-25 23:36:58
Message-ID: 20010825233659.B604E12BE6@pinguin.gl.aser.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Harvey 2001-08-25 23:59:37 Re: FOREIGN KEY after CREATE TABLE?
Previous Message Bruce Momjian 2001-08-25 23:26:42 Re: linking hba.c