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 05:22:18
Message-ID: 6478774.999494538581.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 before 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 and what syntax does it follow.

Thankyou in advance.

Stay Safe & Happy.

:* TankGirl

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Norbert Zoltan Toth 2001-09-03 09:01:48 query not using index
Previous Message Randall Perry 2001-09-03 00:01:27 Perl won't eval PgSQL boolean value