Postgres support (foreign servers)

[nene]

Foreign servers

• CREATE SERVER
  • IF NOT EXISTS
  • server_name
  • TYPE 'server_type'
  • VERSION 'server_version'
  • FOREIGN DATA WRAPPER fdw_name
  • OPTIONS ( option 'value' [, ... ] )
• ALTER SERVER
  • VERSION 'new_version'
  • OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME TO new_name
• DROP SERVER
  • IF EXISTS
  • name, ...
  • CASCADE | RESTRICT
• IMPORT FOREIGN SCHEMA
  • remote_schema
  • { LIMIT TO | EXCEPT } ( table_name [, ...] )
  • FROM SERVER server_name
  • INTO local_schema
  • OPTIONS ( option 'value' [, ... ] )

Foreign data wrappers

• CREATE FOREIGN DATA WRAPPER
  • name
  • HANDLER handler_function | NO HANDLER
  • VALIDATOR validator_function | NO VALIDATOR
  • OPTIONS ( option 'value' [, ... ] )
• ALTER FOREIGN DATA WRAPPER
  • name
  • HANDLER handler_function | NO HANDLER
  • VALIDATOR validator_function | NO VALIDATOR
  • OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
  • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • RENAME TO new_name
• DROP FOREIGN DATA WRAPPER
  • IF EXISTS
  • name, ...
  • CASCADE | RESTRICT

User mappings for foreign servers

• CREATE USER MAPPING
  • IF NOT EXISTS
  • FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }
  • SERVER server_name
  • OPTIONS ( option 'value' [ , ... ] )
• ALTER USER MAPPING
  • FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | SESSION_USER | PUBLIC }
  • SERVER server_name
  • OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
• DROP USER MAPPING
  • IF EXISTS
  • FOR { user_name | USER | CURRENT_ROLE | CURRENT_USER | PUBLIC }
  • SERVER server_name