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 vote239 views1 answer
Create-table-with-index-organization
SQL
5 votes208 views1 answer
Add column table sql default value
SQL
5 votes410 views2 answers
How to ascending order in sql
SQL
15 votes197 views2 answers
Open postgress in terminal mac
SQL
0 vote262 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote248 views1 answer
How to pass list as parameter in SQL query
SQL
4 votes191 views1 answer
Oracle session date format
SQL
1 vote201 views1 answer
Sqlalchemy order by descending
SQL
7 votes189 views1 answer
Sql management studio display line numbers
SQL
0 vote201 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL