I want to import a VIEW from sqlserver to pg with odbc_fdw .
and the command is as follows:
IMPORT FOREIGN SCHEMA "dbo" LIMIT to ("View_test") FROM SERVER erp_sqlserver2 INTO "erp_test" OPTIONS ( odbc_DATABASE 'testDB');
But when I query with "select * from View_test" ,it response "ERROR: Executing ODBC query" ...
I'll be grateful if anyone can offer help ...
suishaojian
commented
3 years ago
I want to import a VIEW from sqlserver to pg with odbc_fdw . and the command is as follows:
IMPORT FOREIGN SCHEMA "dbo" LIMIT to ("View_test") FROM SERVER erp_sqlserver2 INTO "erp_test" OPTIONS ( odbc_DATABASE 'testDB');But when I query with "select * from View_test" ,it response "ERROR: Executing ODBC query" ... I'll be grateful if anyone can offer help ...