Postgresql heritage

CREATE TABLE villes (
    nom             text,
    population      float,
    altitude        int     -- (en pied)
);

CREATE TABLE capitales (
    etat           char(2)
) INHERITS (villes);

Source: docs.postgresql.fr

Similar codes

53 votes220 views6 answers
How to install mysql ubuntu
SQL
0 vote153 views1 answer
Mssql find deadlocks
SQL
0 vote115 views1 answer
Drush run sql select
SQL
6 votes112 views2 answers
Drop foreign key
SQL
0 vote102 views1 answer
Mysql earlier than date
SQL
0 vote115 views1 answer
Sub query in linq
SQL
0 vote125 views1 answer
Groupby error in mysql
SQL
0 vote119 views1 answer
Sql select first and last record of each group
SQL
28 votes131 views6 answers
Foreign key
SQL
0 vote129 views1 answer
Get the next column of a table in mysql
SQL