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

1 vote361 views1 answer
Alphabetical order mysql
SQL
24 votes353 views4 answers
Delete db postgres
SQL
3 votes353 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote318 views1 answer
Declaring variables in pl sql
SQL
0 vote351 views1 answer
Ver usuarios mysql
SQL
4 votes321 views1 answer
Wilayah indonesia database
SQL
0 vote364 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes353 views1 answer
Tsql copy table
SQL
2 votes363 views2 answers
Mysql add hours to time field
SQL
0 vote356 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL