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 vote379 views1 answer
Sql server information_schema temp tables
SQL
0 vote385 views1 answer
Check user sql password from command line
SQL
0 vote400 views1 answer
Postgres list tables and row counts
SQL
0 vote387 views1 answer
Mysql multiple group by
SQL
11 votes362 views3 answers
Sqlite3 create table from another table
SQL
16 votes381 views1 answer
Mysql reset auto increment value
SQL
1 vote350 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote366 views1 answer
Sql character index
SQL
0 vote400 views1 answer
FIND most frequent word in sql server
SQL
2 votes346 views2 answers
Mysql on duplicate key ignore
SQL