Re: alter table, add foreign key constraint - Mailing list pgsql-general

On Tue, 17 Oct 2000, Matthew Kennedy wrote:

> Is it possible to perform an alter table with add foreign key constraint
> in PostgreSQL? We are trying to support multiple DBMS in our project by
> keeping to a common, compatible denominator. Oracle, supports such a
> construct. Does (or might) PostgreSQL support this feature?

Yes...

ALTER TABLE <table> ADD <constraint definition>

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
Stealing a rhinoceros should not be attempted lightly.