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

3 votes331 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
7 votes324 views1 answer
Connect mysql docker
SQL
2 votes333 views1 answer
Mysql last 7 days including today
SQL
0 vote308 views1 answer
Find number of entries sql
SQL
0 vote310 views1 answer
Sql auto_increment syntax
SQL
15 votes316 views4 answers
Pl sql
SQL
0 vote330 views1 answer
Where field is null sql knex
SQL
0 vote370 views1 answer
How to find date from date table in sql
SQL
0 vote334 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote365 views2 answers
Identity syntax in sql
SQL