Select on Foreign table is not working

Поиск
Список
Период
Сортировка
От Sahil Khan
Тема Select on Foreign table is not working
Дата
Msg-id CAHgsOX8VO5X9C5U4-U3buJPazGdqsVZQfJ7BEKpobWcJ8gToag@mail.gmail.com
обсуждение исходный текст
Ответы Re: Select on Foreign table is not working  (Holger Jakobs <holger@jakobs.com>)
Re: Select on Foreign table is not working  (Samed YILDIRIM <samed@reddoc.net>)
Список pgsql-admin
Hi,

Hope you are doing well,

I have created a foreign table on my postgresql server to select the data on external table which is reside on MS SQL Server, everything went well from installing to freetds and installing and configuring tds_fdw tool, and created foreign server and user mapping then created foreign table, but when i do select from table_name then it throws an error which is i mentioned below as.

ERROR:  DB-Library error: DB #: 20018, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 16


will be highly grateful for your valuable suggestions, where to look for to get this done.

Thank You.




Regards,
Sahil | +919892569610

В списке pgsql-admin по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: csv vs json?
Следующее
От: Holger Jakobs
Дата:
Сообщение: Re: Select on Foreign table is not working