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

3 votes284 views2 answers
Sql server current date without time
SQL
8 votes281 views10 answers
Sql
SQL
0 vote276 views1 answer
Sql get date from timestamp
SQL
1 vote295 views2 answers
Truncate table sqlite
SQL
1 vote259 views1 answer
Base nosql
SQL
10 votes264 views4 answers
Join with multiple conditions sql
SQL
1 vote294 views3 answers
How to pass password to mysql command line
SQL
0 vote262 views1 answer
Declarative base sqlalchemy
SQL
1 vote273 views2 answers
Postgres cast as decimal
SQL
1 vote288 views2 answers
Snowflake alter column data type
SQL