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 votes230 views1 answer
Rails execute sql
SQL
0 vote236 views1 answer
Query for backup a database at another location in file system
SQL
0 vote225 views1 answer
Sql delete from with relation
SQL
24 votes250 views6 answers
Sql change table name
SQL
0 vote226 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote216 views1 answer
Mysql coonect sample code
SQL
1 vote182 views1 answer
Mysql collation
SQL
0 vote235 views1 answer
Python mysql show databases
SQL
0 vote213 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
3 votes222 views2 answers
Sql paging query
SQL