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 vote281 views3 answers
Getdate function in postgresql
SQL
3 votes263 views2 answers
WhereIn SQL
SQL
0 vote284 views1 answer
Select from column mysql
SQL
0 vote275 views1 answer
Renombrar tabla mysql
SQL
2 votes273 views2 answers
Checking data type in sql server
SQL
0 vote283 views1 answer
Mysql set variable to today's date
SQL
0 vote261 views1 answer
Python mysql query where
SQL
0 vote279 views1 answer
Postgresql interview questions
SQL
1 vote323 views1 answer
Mariadb get column names from table
SQL
4 votes276 views2 answers
Postgre sql create table
SQL