Re: Add Foreign Keys To Table - Mailing list pgsql-general

On Thu, 7 Jul 2011, John R Pierce wrote:

> Since your PK of station_type is a composite, your foreign key must also be
> composite.
>
> CREATE TABLE stuffed (
>    id serial;
>    otherestuffs text;
>    sta varchar(50),
>    sec varchar(50),
>    FOREIGN KEY (sta, sec) REFERENCES station_type(sta_type, secondary_type)
> );

   Thanks, John, for showing me how to apply this approach.

Rich