Contents

• TDS Foreign data wrapper
  • Creating a User Mapping
    • Options
    • Example

TDS Foreign data wrapper

• Author: Geoff Montee
• Name: tds_fdw
• File: tds_fdw/UserMappingCreation.md

Creating a User Mapping

Options

User mapping parameters accepted:

• username

Required: Yes

The username of the account on the foreign server.

• password

Required: Yes

The password of the account on the foreign server.

Example

CREATE USER MAPPING FOR postgres
    SERVER mssql_svr 
    OPTIONS (username 'sa', password '');