error in SQL server in query to a linked server

Navigation
0

Good afternoon, I have linked sqlServer with PostgreSQL, the connection is successful, I can see the databases that I have in PostgreSQL except for the database tables, otherwise it is when I want to access the tables in the database that comes by default "postgres" Attached image of the error when I try to see the tables.

Thank you.

    
asked by andres garcia 28.09.2017 в 22:41
source

1 answer

0

When you perform a Select to a table of a linked server the syntax is. 

Select * from [ServidorVinculado]...[NombreTabla]
    
answered by 28.09.2017 в 22:51
Error creating service in the background android why did not my input submit respond?