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 votes193 views2 answers
Mysql delete user if exists
SQL
0 vote179 views1 answer
MySql Modify Increment
SQL
2 votes185 views1 answer
Sql server case sensitive search
SQL
0 vote198 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote167 views2 answers
Sql select inside select
SQL
0 vote183 views1 answer
Grepper sql workbench download
SQL
0 vote173 views1 answer
Mysql find db contarint
SQL
0 vote189 views1 answer
Sql select upcoming birthdays
SQL
0 vote186 views2 answers
Sql update multiple tables
SQL
0 vote183 views1 answer
How to check the port of mysql installation in mac
SQL