Re: Add Foreign Keys To Table

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