Contents

Change history
References
Categories
See also

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)
PostgreSQL 10
- support for table partitioning via the CREATE FOREIGN TABLE ... PARTITION OF syntax added (commit f0e44751)
PostgreSQL 9.5
- support for CHECK constraints added (commit fc2ac1fb)
- support for the INHERITS clause added (commit cb1ca4d8)
PostgreSQL 9.3
- per-column COLLATION support added (commit a0c6dfee)
- named column NULL constraints supported (commit a0c6dfee)
- column DEFAULT supported (commit a0c6dfee)
PostgreSQL 9.2
- column-level OPTIONS clause added (commit c4096c76)
PostgreSQL 9.1
- added (commit 0d692a0d)

References

PostgreSQL documentation: CREATE FOREIGN TABLE

Categories

See also

ALTER FOREIGN TABLE, DROP FOREIGN TABLE, foreign table