CREATE FOREIGN TABLE
Synopsis
Use the CREATE FOREIGN TABLE
command to create a foreign table.
Syntax
create_foreign_table ::= CREATE FOREIGN TABLE [ IF NOT EXISTS ]
table_name ( [ foreign_table_elem [ , ... ] ]
) SERVER server_name
[ OPTIONS ( fdw_options ) ]
create_foreign_table
Semantics
Create a new foreign table named table_name. If table_name already exists in the specified database, an error will be raised unless the IF NOT EXISTS
clause is used.
Collation
The COLLATE
clause can be used to specify a collation for the column.
Server
The SERVER
clause can be used to specify the name of the foreign server to use.
Options:
The OPTIONS
clause specifies options for the foreign table. The permitted option names and values are specific to each foreign data wrapper. The options are validated using the FDW’s validator function.
Examples
Basic example.
yugabyte=# CREATE FOREIGN TABLE mytable (col1 int, col2 int) SERVER my_server OPTIONS (schema 'external_schema', table 'external_table');