Thank you Geoff.
Actually I have a problem - maybe you can point me in the right direction?
CREATE EXTENSION tds_fdw;
CREATE EXTENSION
CREATE SERVER ms FOREIGN DATA WRAPPER tds_fdw OPTIONS (servername 'ms');
CREATE SERVER
CREATE USER MAPPING FOR postgres SERVER ms
OPTIONS (username 'bzzt', password 'blurp');
CREATE USER MAPPING
CREATE FOREIGN TABLE test ( id integer ) SERVER ms OPTIONS ( database
'MyApp', query 'select 1' );
CREATE FOREIGN TABLE
SELECT * FROM test;
NOTICE: DB-Library notice: Msg #: 5701, Msg state: 2, Msg: Changed
database context to 'master'., Server: ms, Process: , Line: 1, Level:
0
NOTICE: DB-Library notice: Msg #: 5703, Msg state: 1, Msg: Changed
language setting to us_english., Server: ms, Process: , Line: 1,
Level: 0
NOTICE: DB-Library notice: Msg #: 40508, Msg state: 1, Msg: USE
statement is not supported to switch between databases. Use a new
connection to connect to a different database., Server: ms, Process: ,
Line: 1, Level: 16
ERROR: DB-Library error: DB #: 40508, DB Msg: General SQL Server
error: Check messages from the SQL Server, OS #: -1, OS Msg: (null),
Level: 16
Thanks,
Filip
On Mon, May 18, 2015 at 6:23 PM, Geoff Montee <geoff.montee@gmail.com> wrote:
> Hi Filip,
>
> On Mon, May 18, 2015 at 7:52 AM, Filip Rembiałkowski
> <filip.rembialkowski@gmail.com> wrote:
>> Hi.
>>
>> I will be happy to hear your opinion which one is better - odbc_fdw or tds_fdw?
>>
>> In terms of performance / stability / convenience.
>>
>> (Pg on OpenSuse, MS SQL on Win2008 )
>>
>> Thanks!
>>
>
> I'm the developer of tds_fdw. I originally developed tds_fdw because I
> wasn't able to get odbc_fdw working with FreeTDS. If you try out
> odbc_fdw, hopefully you'll have better luck than I did!
>
> If you decide to try out tds_fdw and you have any problems or run into
> any bugs, feel free to ask for help on the GitHub page:
>
> https://github.com/GeoffMontee/tds_fdw
>
> Good luck!
>
> Thanks,
>
> Geoff