Using foreign keys : FOREIGN KEY « Constraints « PostgreSQL






Using foreign keys


postgres=#
postgres=# -- Foreign Keys
postgres=#
postgres=# CREATE TABLE cities (
postgres(#        city     varchar(80) primary key,
postgres(#        id       int
postgres(# );
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cities_pkey" for table "cities"
CREATE TABLE
postgres=#
postgres=# CREATE TABLE weather (
postgres(#        city      varchar(80) references cities(city),
postgres(#        temp_lo   int,
postgres(#        temp_hi   int,
postgres(#        prcp      real,
postgres(#        date      date
postgres(# );
CREATE TABLE
postgres=#
postgres=# insert into cities values ('Berkeley', 0);
INSERT 0 1
postgres=#
postgres=# INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28');
INSERT 0 1
postgres=#
postgres=# drop table weather;
DROP TABLE
postgres=# drop table cities;
DROP TABLE
postgres=#
postgres=#
           
       








Related examples in the same category

1.Define foreign key for a table
2.Reference two two columns as foreign key column
3.Adding constraints (FOREIGN KEY) to a table
4.Adding a constraint to an existing table: add foreign key to table
5.Create FOREIGN KEY
6.ALTER TABLE employee ADD FOREIGN KEY (group_id) REFERENCES product_groups