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

24 votes192 views4 answers
Mssql get all table names
SQL
3 votes193 views1 answer
Sql double index
SQL
17 votes203 views4 answers
Set mysql Password
SQL
0 vote185 views1 answer
Sql if else in select
SQL
0 vote182 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
4 votes181 views1 answer
Psql get sequences
SQL
6 votes206 views3 answers
Create database mysql utf8
SQL
15 votes334 views3 answers
Postgresql change column type
SQL
5 votes174 views1 answer
Oracle scan source ddl
SQL
6 votes235 views1 answer
Postgresql get year
SQL