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 votes138 views1 answer
Pandas to sql index
SQL
0 vote151 views2 answers
Faster mysql imports
SQL
3 votes142 views1 answer
Stpop start psql server
SQL
0 vote163 views1 answer
SQL joins in python
SQL
5 votes143 views3 answers
Oracle first day of last year
SQL
0 vote135 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote132 views1 answer
Insert data from stored procedure into table
SQL
0 vote142 views1 answer
Create table database in psql
SQL
2 votes153 views1 answer
Sql server find columns list in tables
SQL
0 vote145 views1 answer
Sql dmv to capture updates
SQL