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

4 votes198 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote165 views1 answer
Mysql where sum > 0
SQL
2 votes145 views1 answer
Mysql time ago difference
SQL
7 votes131 views2 answers
Show size database mysql
SQL
0 vote162 views1 answer
MySQL get all previous date record
SQL
0 vote156 views1 answer
Reset postgresql password windows
SQL
4 votes145 views1 answer
Mysql biginteger size
SQL
0 vote132 views1 answer
Object Information
SQL
0 vote147 views1 answer
Mysql group by derived column
SQL
0 vote140 views1 answer
Test sql query
SQL