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

1 vote347 views2 answers
Mysql filter by date mount
SQL
0 vote348 views1 answer
Sql #region
SQL
0 vote339 views1 answer
How to find sql server name
SQL
3 votes338 views1 answer
Ssh check mysql version
SQL
1 vote333 views1 answer
Load sql into mamp
SQL
0 vote341 views1 answer
Sql delete where x or y or z
SQL
0 vote377 views1 answer
Spark sql grows beyond 64 kb
SQL
8 votes301 views8 answers
Second highest salary in mysql
SQL
2 votes350 views1 answer
Set column to not null mysql
SQL
37 votes536 views3 answers
Sql check duplicate value in column
SQL