This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 81%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Connection status is success.
Query 1: select * from openquery(XYZ,'select * from People')
Status : Success
Query 2: select * from XYZ.NewDB.[public].People
status: FAiled.
Error :
OLE DB provider "MSDASQL" for linked server "XYZ" returned message "ERROR: cross-database references are not implemented: "NewDb.public.people";
Error while executing the query".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table ""newDB"."public"."people"" from OLE DB provider "MSDASQL" for linked server "xyz".
Please help..
Thanks in Advance...
It appears to be a limitation with the ODBC driver you are using.
Intellisoft has an OLE DB provider for Postgres, and using a linked server set up with this provider, I was able to query a table in my Postgres database in Azure using four-part notation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi @Raju MP ,
It seems to be related to the driver you are using.
Please refer to the following article, which introduces the use of a linked server to query Postgresql with a four-part naming.
https://www.mssqltips.com/sqlservertip/3662/sql-server-and-postgresql-linked-server-configuration--part-2/