Purpose
Creates a foreign server object and associates an import table operator and an export table operator with it.
When you create a server object, you can customize it based on its purpose. You can define multiple server objects for the same remote database, each with different characteristics needed by different users.
Syntax
CREATE FOREIGN SERVER server_name [ EXTERNAL SECURITY [ INVOKER | DEFINER ] TRUSTED authorization_name ] [ using_option ] [ DO IMPORT WITH operator_option [, DO EXPORT WITH operator_option ] ] [;]
Syntax Elements
- using_option
USING name ( { 'value' | scalar_subquery | using_parameter | system_variable } )
- operator_option
[ database_name. ] table_operator using_option