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 vote221 views1 answer
Oracle compile schema
SQL
1 vote212 views1 answer
Oracle split string
SQL
33 votes222 views6 answers
Change column name in mysql
SQL
1 vote217 views1 answer
SQL date part only of datetime
SQL
-1 vote213 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote219 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote218 views1 answer
Sql padd let with zeros
SQL
0 vote219 views1 answer
Sql server select furst day of current year
SQL
1 vote227 views1 answer
Oracle undo usage per session
SQL
0 vote218 views1 answer
MySQL - How to find word with the most similar beginning
SQL