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

6 votes180 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote180 views1 answer
How to create an SQL save method in ruby
SQL
0 vote192 views1 answer
Sql server select record with max id
SQL
10 votes193 views6 answers
Mysql delete duplicates
SQL
0 vote181 views1 answer
St_buffer mysql
SQL
3 votes179 views1 answer
Index using in query plsql
SQL
0 vote190 views1 answer
Postgres statistics
SQL
0 vote193 views2 answers
How to relationship query two different tables in MySQL
SQL
9 votes194 views1 answer
Oracle get table schema
SQL
0 vote196 views2 answers
Disadvantages of stored procedures sql
SQL