On 04/09/2018 02:37 PM, karthik kumar wrote:
>
>
> On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 04/09/2018 02:10 PM, karthik kumar wrote:
> Assuming using this:
>
> https://github.com/ZhengYang/odbc_fdw
>
> I believe that should be username and password per above link:
>
> "CREATE USER MAPPING FOR postgres
> SERVER odbc_server
> OPTIONS (username 'root', password '');
> "
>
> Yes.
>
>
> Does 'yes' mean you changed this:
>
> CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (odbc_UID
> 'db2inst1', odbc_PWD 'db2inst1');
>
> to this?:
>
> CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (username
> 'db2inst1', password 'db2inst1');
>
>
> If i try to use username it throws error as invalid option
>
> postgres=# CREATE SERVER driver_db5 FOREIGN DATA WRAPPER odbc_fdw
> OPTIONS (dsn 'sample');
> CREATE SERVER
>
> postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS
> (username 'db2inst1', password 'db2inst1');
> ERROR: invalid option "username"
> HINT: Valid options in this context are: <none>
You are using the extension from below, correct?:
https://github.com/ZhengYang/odbc_fdw
In psql what does the below show?:
\dx
What happens if you do not include the OPTIONS?
>
> postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS
> (odbc_UID 'db2inst1', odbc_PWD 'db2inst1');
> CREATE USER MAPPING
>
>
>
> Thanks,
> Karthik.
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
