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

4 votes201 views3 answers
Rename table column postgresql
SQL
8 votes173 views2 answers
Mysql get first x characters
SQL
0 vote179 views4 answers
Sql year
SQL
0 vote179 views1 answer
Char varchar nvarchar sql
SQL
2 votes178 views2 answers
Get all tables using like
SQL
1 vote170 views2 answers
Mysql type conversion
SQL
14 votes195 views6 answers
Auto_increment mysql
SQL
1 vote181 views2 answers
Datetrunc hour snowflake
SQL
2 votes227 views1 answer
Orcale index size
SQL
0 vote163 views1 answer
Metada in sql
SQL