Re: Create Foriegn Key - Mailing list pgsql-general

From Ing. Roberto Andrade Fonseca
Subject Re: Create Foriegn Key
Date
Msg-id Pine.LNX.4.44.0306061948150.1392-100000@ns0.interservice.net
Whole thread Raw
In response to Create Foriegn Key  ("David Busby" <busby@pnts.com>)
List 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@abl.com.mx


pgsql-general by date:

Previous
From: Nagib Abi Fadel
Date:
Subject: How to merge 3 databases in one database quickly
Next
From: Brian Avis
Date:
Subject: Backups and restores.