CREATE FOREIGN TABLE¶
Create a foreign table
Table of contents
Synopsis¶
CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_ident ([
{ column_name data_type }
[, ... ]
])
SERVER server_name
[ OPTIONS ( option 'value' [, ... ] ) ]
Description¶
CREATE FOREIGN TABLE is DDL statement that creates a new foreign table.
A foreign table is a view onto data in a foreign system.
To create a foreign table you must first create a foreign server using CREATE SERVER.
The name of the table must be unique, and distinct from the name of other relations like user tables or views.
Foreign tables are listed in the information_schema.tables view and
information_schema.foreign_tables. You can use SHOW CREATE TABLE
to view the definition of an existing foreign table.
Creating a foreign table requires AL permission on schema or cluster level.
A foreign table cannot be used in CREATE PUBLICATION for logical replication.
Clauses¶
IF NOT EXISTS¶
Do not raise an error if the table already exists.
OPTIONS¶
- option value:
Key value pairs defining foreign data wrapper specific options for the server .See Foreign Data Wrappers for the foreign data wrapper specific options.