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 votes321 views4 answers
Mysql delete duplicate rows
SQL
0 vote354 views1 answer
Mysql remove bad character from all fields
SQL
0 vote324 views1 answer
Postgres where
SQL
4 votes370 views1 answer
Mysql query first character
SQL
3 votes336 views1 answer
Sql replace character in string in all records
SQL
0 vote309 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote367 views2 answers
Mysql show foreign keys
SQL
3 votes386 views2 answers
See mysql users ubuntu
SQL
0 vote385 views1 answer
Mysql concatenate select results
SQL
2 votes324 views1 answer
Sql column values comma separated
SQL