> 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
See:
http://www.postgresql.org/idocs/index.php?sql-altertable.html
The part you're interested in says:
To add a foreign key constraint to a table:
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address)
REFERENCES addresses(address) MATCH FULL
Hope this helps,
-- Joe
