Postgresql inheritance

CREATE TABLE cities (
  name       text,
  population real,
  elevation  int     -- (in ft)
);

CREATE TABLE capitals (
  state      char(2) UNIQUE NOT NULL
) INHERITS (cities);

Source: postgresql.org

Similar codes

3 votes334 views1 answer
RENAME table pl sql
SQL
0 vote359 views1 answer
Set column in all row mysql
SQL
1 vote346 views1 answer
Tsql get beginning of year
SQL
0 vote345 views1 answer
Oracle dynamic select into
SQL
0 vote351 views1 answer
Postgresql delete type
SQL
0 vote366 views1 answer
Offset in postgresql example
SQL
0 vote328 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote332 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote347 views1 answer
Sql select random procentage from rows
SQL
2 votes375 views1 answer
Q operator in oracle
SQL