Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

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