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

10 votes175 views1 answer
Oracle object dependencies
SQL
1 vote185 views1 answer
Where not in array sql
SQL
0 vote185 views1 answer
Get substract count sql
SQL
2 votes160 views1 answer
Sql server find table name
SQL
0 vote206 views1 answer
Compress sql file database ubuntu
SQL
1 vote187 views1 answer
Add current timestamp in mysql
SQL
0 vote175 views1 answer
Postgresql comandos basicos
SQL
1 vote167 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote182 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote171 views1 answer
Group by 15 minute interval sql server
SQL