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 vote226 views1 answer
Get last updated row sql server
SQL
0 vote249 views1 answer
Create dump file mysql workbench
SQL
10 votes227 views1 answer
All_dependencies
SQL
0 vote226 views1 answer
Postgresql create table with boolean column
SQL
3 votes239 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote183 views1 answer
Denied
SQL
1 vote243 views1 answer
Tsql get beginning of year
SQL
0 vote243 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote242 views1 answer
Mysql 8 error on identified by
SQL
16 votes243 views4 answers
Find duplicates mysql
SQL