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

0 vote202 views1 answer
Sql server delete records with specific date
SQL
0 vote200 views1 answer
Postgresql import data from csv
SQL
0 vote187 views1 answer
Sql date time query find
SQL
3 votes155 views1 answer
Postgresql if null then 0
SQL
0 vote170 views1 answer
Get first 3 letter of department name in sql
SQL
5 votes181 views1 answer
Find table from column name in sql
SQL
0 vote150 views1 answer
Get who is hired in month in sql
SQL
11 votes159 views4 answers
MYSQL LOGIN
SQL
1 vote207 views1 answer
Sample clause in sql
SQL
7 votes168 views2 answers
Mysql get year from date
SQL