Postgres Pro
Downloads
Home   >   mailing lists

Adding a Foreign key! - Mailing list pgsql-general

From tankgirl@worldonline.es
Subject Adding a Foreign key!
Date
Msg-id 6460907.999523987896.JavaMail.root@macaca.worldonline.es
Whole thread Raw
List pgsql-general
Tree view 
 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

pgsql-general by date:

Previous
From: "Andrew Snow"
Date:
Subject: Re: PL/java?
Next
From: "Andrew Snow"
Date:
Subject: Re: Perl won't eval PgSQL boolean value