Am mai incercat si in felul urmator
select * from
opendatasource('PostgreSQL', 'Data Source=localhost:5432;User ID=sqlrepl;Password=sqlrepl').slave..tab1

cu eroarea
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "PostgreSQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7304, Level 16, State 2, Line 1
Cannot connect using OLE DB provider "PostgreSQL" to linked server "(null)". Verify the connection parameters or login credentials associated with this linked server.

apoi am zis sa incerc
select * from
opendatasource('MSDASQL', 'Data Source=PGSLAVE').[slave].[public].[tab1]
unde PGSLAVE este un linked server 

am primit eroarea:
OLE DB provider "MSDASQL" for linked server "(null)" returned message "ERROR: syntax error at or near ""Col1004"";
Error while executing the query".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."id" "Col1004","Tbl1002"."t" "Col1005" FROM "slave"."public"."tab1" "Tbl1002"" against OLE DB provider "MSDASQL" for linked server "(null)".


in schimb daca folosesc
sp_tables_ex @table_server = 'PGSLAVE',
@table_catalog = 'slave',
@table_schema = 'public',
@table_type = 'TABLE'

imi da rezultatul asteptat
slave    public    MSREPL7    TABLE   
slave    public    tab1    TABLE   

daca puteti sa imi zicceti pe unde gresesc de nu imi merge opendatasource

Ma intereseaza dc petnru un linked server cu numele PGSLAVE
nu imi merge o interogare simpla de genu

select * from PGSLAVE...tab1

si imi da eroarea

Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "PGSLAVE".

---

MCP (C Sharp)
Software Engineer,
Cluj Napoca