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

12 votes331 views2 answers
Find duplicates mysql column
SQL
0 vote307 views1 answer
Sql view index
SQL
1 vote325 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote349 views1 answer
Oracle current timestamp insert statement
SQL
0 vote317 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes388 views3 answers
Sql delete duplicate
SQL
0 vote349 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
23 votes342 views3 answers
Sql where contains part of string
SQL
0 vote346 views1 answer
Mysql last 6 months
SQL
0 vote306 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL