当前位置：Gxlcms >
数据库问题 >
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
时间：2021-07-01 10:21:17
帮助过：23人阅读
TABLE directors (
id SERIAL PRIMARY KEY,
name VARCHAR(
100)
UNIQUE NOT NULL
);
CREATE TABLE movies (
id SERIAL PRIMARY KEY,
title VARCHAR(
100)
NOT NULL,
release_date DATE,
count_stars INTEGER,
director_id INTEGER REFERENCES directors(id)
);
Now, if we try to insert to movies table some new data which contains director_id is not inside directors table, it will report error
[PostgreSQL] Use Foreign Keys to Ensure Data Integrity in Postgres
标签：post new ted direct har about pos cto table
