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

2 votes250 views1 answer
Oracle table size
SQL
2 votes268 views1 answer
When matched in sql server
SQL
0 vote269 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote277 views1 answer
Table user postgres
SQL
2 votes251 views1 answer
Sql server conection string
SQL
1 vote256 views1 answer
Sql server select rows by distinct column
SQL
0 vote278 views1 answer
Oracle insert single quote in string
SQL
1 vote285 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote276 views1 answer
Sql server rtrim everything after character
SQL
27 votes255 views4 answers
Get all tables with column name sql
SQL