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 vote90 views1 answer
Clear query cache sql server
SQL
1 vote110 views1 answer
Pl sql create table from another table
SQL
0 vote116 views1 answer
Creating a simple notify in postgresql
SQL
4 votes100 views4 answers
What is primary key
SQL
0 vote94 views1 answer
Difference between cross apply and inner join
SQL
0 vote102 views1 answer
Myswql show full processlist
SQL
11 votes105 views3 answers
How to get last row of table in sql
SQL
0 vote109 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote172 views1 answer
Mysql get nested records
SQL
2 votes108 views1 answer
Oracle drop table free up space
SQL