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

2 votes152 views1 answer
Oracle drop sequence if exists
SQL
0 vote142 views1 answer
Mysql 8 geo to json
SQL
-1 vote190 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote167 views1 answer
How to get table id sequence postgres
SQL
0 vote132 views1 answer
Mssql current date
SQL
1 vote151 views1 answer
Vagrant mysql downgrade version
SQL
0 vote144 views1 answer
Python connect microsoft sql server
SQL
1 vote165 views1 answer
Print year of a date sql
SQL
-1 vote140 views8 answers
Create Trigger in phpMyAdmin
SQL
20 votes153 views6 answers
Creating a table in sql
SQL