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

-1 vote155 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
9 votes153 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote140 views1 answer
Execut sql python
SQL
0 vote158 views1 answer
Mysql enter ubuntu
SQL
4 votes141 views1 answer
To date oracle with time
SQL
0 vote166 views1 answer
How to find sql server name
SQL
0 vote146 views1 answer
PSQL qith variables
SQL
0 vote156 views1 answer
How we can perform acid Operations in sql with examples
SQL
-1 vote142 views1 answer
Mac mysql workbench console
SQL
1 vote156 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL