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

0 vote357 views1 answer
Mariadb change column type
SQL
1 vote289 views1 answer
Oracle sql create or replace view
SQL
11 votes274 views1 answer
Reset identity sql server
SQL
8 votes269 views2 answers
Alter column name in mssql
SQL
12 votes303 views4 answers
Mysql get date difference in hours
SQL
0 vote316 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote284 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote354 views2 answers
Remove mysql workbench ubuntu
SQL
60 votes508 views6 answers
Add column in sql
SQL
0 vote284 views1 answer
Go install mysql
SQL