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

17 votes258 views3 answers
How to change a collumn name in sql
SQL
-1 vote259 views3 answers
Psql get last rows
SQL
-1 vote279 views3 answers
My sql alter table
SQL
0 vote264 views1 answer
Get null value in sql
SQL
0 vote259 views1 answer
Turnicate in mysql
SQL
0 vote275 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote268 views1 answer
Guid string to binary better
SQL
0 vote270 views1 answer
Custom row number
SQL
0 vote250 views1 answer
Oracle drop default value
SQL
0 vote280 views1 answer
Consulta alias con inner join
SQL