Re: Create Foriegn Key

From: "Ing(dot) Roberto Andrade Fonseca" <randrade(at)abl(dot)com(dot)mx>
To: David Busby <busby(at)pnts(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create Foriegn Key
Date: 2003-06-07 00:49:06
Message-ID: Pine.LNX.4.44.0306061948150.1392-100000@ns0.interservice.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:
On Wed, 4 Jun 2003, David Busby wrote:

> List,
> How can I create a Foriegn Key after my table is created? I cannot find
> in docs (or google) anywhere.
Something likke this must work for you:

ALTER TABLE documento_mensaje_foro
ADD FOREIGN KEY (id_mensaje)
REFERENCES mensaje_foro ;
--
Saludos,

Roberto Andrade Fonseca
randrade(at)abl(dot)com(dot)mx

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Wilson 2003-06-07 02:22:44 Re: Create Foriegn Key
Previous Message Brian Avis 2003-06-07 00:09:03 Backups and restores.