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 vote270 views1 answer
Mysql if example
SQL
36 votes323 views6 answers
Rename table sql
SQL
0 vote327 views1 answer
Oracle locked objects
SQL
0 vote315 views1 answer
ORA-00942
SQL
0 vote332 views1 answer
View psql output in horizontal scrolling
SQL
0 vote330 views1 answer
Mysql remove last character
SQL
8 votes345 views2 answers
Between operator
SQL
0 vote318 views1 answer
Delete data from database sqlite android
SQL
1 vote324 views1 answer
Mysql size int
SQL
2 votes302 views1 answer
Date_format for time sql
SQL