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 vote133 views1 answer
Get who is hired in month in sql
SQL
10 votes142 views1 answer
Dba_dependencies
SQL
0 vote144 views1 answer
Tsql delete all rows
SQL
4 votes184 views1 answer
Postgresql change default value
SQL
0 vote193 views1 answer
Wordpress sql find and replace
SQL
21 votes151 views5 answers
Oracle all tables
SQL
-1 vote140 views1 answer
Round up and down sql
SQL
5 votes182 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes142 views1 answer
Sql like variable
SQL
0 vote157 views1 answer
Sql on-premises
SQL