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

2 votes153 views1 answer
Query to find table size in oracle 12c
SQL
10 votes138 views2 answers
Tsql merge example
SQL
27 votes138 views4 answers
Get all tables with column name sql
SQL
11 votes145 views1 answer
Ddl view
SQL
1 vote135 views1 answer
Oracle select first result
SQL
1 vote134 views1 answer
Alphabetical order mysql
SQL
0 vote130 views1 answer
How to connect postgresql database with java
SQL
0 vote130 views1 answer
Mysql find missing values
SQL
0 vote146 views1 answer
Mysql get date diff in months
SQL
0 vote143 views1 answer
Psql get table data types
SQL