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 vote301 views3 answers
Mysql regex replace
SQL
0 vote302 views1 answer
Mysql last 6 months
SQL
1 vote308 views1 answer
Where not in array sql
SQL
0 vote297 views1 answer
Psql generate id in existing database
SQL
0 vote260 views1 answer
Mysql create table columns with spaces
SQL
3 votes278 views1 answer
Oracle user quota unlimited
SQL
0 vote295 views1 answer
How to make full text search dynamic in mysql
SQL
2 votes315 views1 answer
Mysql id of inserted row
SQL
56 votes547 views5 answers
Psql create user
SQL
0 vote297 views1 answer
Last date for each user sql
SQL