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