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

0 vote262 views1 answer
Create function syntax sql server
SQL
0 vote266 views1 answer
Sql anywhere create procedure
SQL
23 votes279 views6 answers
How to create table in sql
SQL
0 vote236 views1 answer
Mysql create table columns with spaces
SQL
0 vote257 views1 answer
Find largest table in mysql database
SQL
0 vote243 views1 answer
Wordpress sql find and replace
SQL
0 vote248 views1 answer
Postgresql copy backup table
SQL
1 vote221 views1 answer
Ms sql how to see active job current run time
SQL
7 votes292 views2 answers
Phpmyadmin change password
SQL
0 vote274 views1 answer
Starting mysql shell lampp ubuntu
SQL