Adding a Foreign key!

From: tankgirl(at)worldonline(dot)es
To: pgsql-general(at)postgresql(dot)org
Subject: Adding a Foreign key!
Date: 2001-09-03 13:33:07
Message-ID: 6460907.999523987896.JavaMail.root@macaca.worldonline.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello everyone,

I know that a Primary Key can be added to a table after it has been created, doing this...

CREATE UNIQUE INDEX table_pkey ON table (atribute);

Well I wonder if a Foreign Key can also be added after the table is already created, and what syntax does it follow.

Thankyou in advance.

Stay Safe & Happy.

:* TankGirl

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Snow 2001-09-03 13:42:15 Re: PL/java?
Previous Message David M. Richter 2001-09-03 12:54:24 Referential Integrity --> SystemTables