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

49 votes262 views6 answers
Get duplicate records in sql
SQL
20 votes181 views5 answers
Mysql reset auto increment to 1
SQL
1 vote225 views1 answer
Default
SQL
1 vote194 views1 answer
Oracle convert run duration to number
SQL
0 vote174 views1 answer
Suse start MySQL
SQL
0 vote222 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote188 views2 answers
Postgresql gset
SQL
2 votes164 views1 answer
Oracle sql drop table purge
SQL
6 votes175 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote167 views1 answer
Limiting query result using where in sql
SQL