[prev] 11 [next]

PostgreSQL Functionality (cont)

Other variations in PostgreSQL's CREATE TABLE
  • TEMPORARY tables
  • PARTITION'd tables
  • GENERATED attribute values   (derived attributes)
  • FOREIGN TABLE   (data stored outside PostgreSQL)
  • table type inheritance 

    create table R ( a integer, b text);
create table S ( x float, y float);
create table T inherits ( R, S );