Contents
CREATE FOREIGN TABLE
A DDL command to create a foreign table
CREATE FOREIGN TABLE
is a DDL command to create a foreign table
for a remote data source accessed via a foreign data wrapper
(FDW).
CREATE FOREIGN TABLE
was added in PostgreSQL 9.1.
Change history
- PostgreSQL 12
- support for generated columns via the
GENERATED ALWAYS AS ... STORED
clause added (commit fc22b662)
- support for generated columns via the
- PostgreSQL 10
- support for table partitioning via the
CREATE FOREIGN TABLE ... PARTITION OF
syntax added (commit f0e44751)
- support for table partitioning via the
- PostgreSQL 9.5
- PostgreSQL 9.3
- PostgreSQL 9.2
- column-level
OPTIONS
clause added (commit c4096c76)
- column-level
- PostgreSQL 9.1
- added (commit 0d692a0d)
References
- PostgreSQL documentation: CREATE FOREIGN TABLE