Postgresql inheritance

CREATE TABLE cities (
  name       text,
  population real,
  elevation  int     -- (in ft)
);

CREATE TABLE capitals (
  state      char(2) UNIQUE NOT NULL
) INHERITS (cities);

Source: postgresql.org

Similar codes

3 votes283 views2 answers
Sqlite show table definition
SQL
1 vote296 views1 answer
Delete specific row in sql
SQL
0 vote286 views1 answer
Turn on foreign keys check mysql
SQL
0 vote294 views1 answer
Mariadb hours between two dates
SQL
0 vote344 views1 answer
Alternative for LIMIT sql
SQL
8 votes302 views2 answers
Alert table name mysql
SQL
0 vote278 views1 answer
Create column that already exists mysql
SQL
9 votes278 views2 answers
Oracle all tables in schema
SQL
0 vote300 views1 answer
Drop procedure sql
SQL
5 votes297 views3 answers
Oracle first day of last year
SQL