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

14 votes242 views6 answers
Auto_increment mysql
SQL
0 vote234 views1 answer
Add multiple field in table sql
SQL
40 votes222 views6 answers
Update table mysql
SQL
0 vote224 views1 answer
Sql server pivot rows to columns
SQL
2 votes268 views1 answer
Postgresql group by month and year
SQL
0 vote228 views1 answer
Ksql quickstart docker
SQL
1 vote233 views1 answer
Drop df constraint sql server
SQL
0 vote219 views1 answer
Mysql to get column name in database
SQL
0 vote223 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
1 vote258 views2 answers
Postgres select from last 3 months
SQL