关于PostgreSQL的表继承
test=# CREATE TABLE cities ( -- 父表test(# name text,
test(# population float,
test(# altitude int
test(# );
CREATE TABLE
test=# CREATE TABLE capitals ( -- 子表
test(# state char(2)
test(# ) INHERITS (cities);
CREATE TABLE
test=# select * from cities;
name | population | altitude
------+------------+----------
(0 rows)
test=# select * from capitals;
name | population | altitude | state
------+------------+----------+-------
(0 rows)
页:
[1]