PostgreSQL 外键示例

create table cities (
city varchar(80) primary key,
location point
);

create table weather (
city varchar(80) references cities(city),
temp_lo int,
temp_hi int,
prcp real,
date date
);