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

3 votes168 views1 answer
Oracle apex warn on unsaved changes
SQL
1 vote118 views1 answer
Oracle finding duplicate records
SQL
4 votes133 views1 answer
Update table from another table oracle
SQL
0 vote141 views2 answers
Which MySQL statement is used to delete data from a database
SQL
4 votes125 views2 answers
Tsql utf to local time
SQL
6 votes143 views2 answers
Where clause in sql
SQL
1 vote151 views2 answers
Sql queries practice
SQL
-1 vote168 views4 answers
Sql view postgresql
SQL
0 vote126 views1 answer
Sql insert tuple
SQL
4 votes141 views1 answer
Mysql biginteger size
SQL