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 vote149 views3 answers
Read all columns of a table sql
SQL
1 vote188 views1 answer
Oracle check table lock
SQL
3 votes181 views5 answers
Duplicate table sql
SQL
1 vote172 views1 answer
Sql server set variable if exists
SQL
1 vote184 views1 answer
Ora-01109 database not open in oracle 19c
SQL
1 vote159 views1 answer
Show table status command in mysql
SQL
0 vote159 views1 answer
Sqlite explain plan
SQL
0 vote143 views1 answer
Data directory postgresql
SQL
1 vote191 views1 answer
Oracle extract minute from date
SQL
0 vote152 views1 answer
Databricks install odbc driver connect to sql server
SQL