FDW user mapping

From: Nikhil Kshirsagar <nkshirsagar(at)reisystems(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: FDW user mapping
Date: 2017-09-28 20:15:10
Message-ID: CY1PR0201MB14685C1AA6901367E6150166DE790@CY1PR0201MB1468.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I want to create foreign data wrapper to access table from SQL server 2012.
I have PostgreSQL9.6. I am facing issues while trying to create user mapping. Please find details below

1. From "http://www.postgresonline.com/journal/archives/361-Foreign-Data-Wrappers-for-PostgreSQL-9.5-windows.html" link, I did download and install PostgreSQL 9.6 w64 FDWs installed with name 'LocalSQL2012ForPg'
2. Installed the ODBC FDW in PostgreSQL with SQL Statement: CREATE EXTENSION odbc_fdw;
3. Ran - CREATE SERVER localsql2012 FOREIGN DATA WRAPPER odbc_fdw OPTIONS (dsn 'LocalSQL2012ForPg');
4. Next I am trying to run below query -
CREATE USER MAPPING
FOR postgres
SERVER localsql2012
OPTIONS (username 'pgadmin',password 'pgadmin');

When I execute above query, I constantly get below error - "ERROR: invalid option "username"
HINT: Valid options in this context are: <none>"

I verified that pgadmin user is present and can access MS SQL server 2012.

Can you please let me know what I am missing?

Thanks & Regards,
Nikhil Kshirsagar
REI Systems, Inc.....Achieving Excellence Together
Ph.No. : (703)-480-7638 | Cell No: (972)-839-9027
nkshirsagar(at)reisys(dot)com<mailto:nkshirsagar(at)reisys(dot)com> | www.reisys.com<http://www.reisys.com/>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stephen Cook 2017-09-29 03:00:56 Re: FDW user mapping
Previous Message legrand legrand 2017-09-22 21:36:15 Re: GUI client