New answers tagged

-2 votes

SQL Server linked server query to Postgres not filtering rows

select * from openquery(PGSTACK,'select * from users limit 1') with the use of openquery you can write much more complex SQL including joins and still have the performance of the indexes on the other ...
Jesse's user avatar
  • 1
0 votes

SQL Server linked server query to Postgres not filtering rows

I think the issue is regarding the TOP keyword... SQL Server doesn't know the equivalent keyword in PostgreSQL (LIMIT), so he fetches all the table content, and after that, applies any filter & ...
figurettipy's user avatar
3 votes
Accepted

SQL Server linked server query to Postgres not filtering rows

Have you set "Use Declare/Fetch" to true in the odbc driver options? From the documentation "If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and ...
Spörri's user avatar
  • 4,704
2 votes

Communicating from a SQL Server 2022 to a SQL Server 2008 over linked server

I happen to have access to similar stack due to... reasons, and there doesn't seem to be any problem of accessing the 2008 (nor 2005) server: EXEC sys.sp_addlinkedserver @server = 'sigge,42008' go ...
siggemannen's user avatar
-2 votes

SQL Server linked server query to Postgres not filtering rows

After having flashbacks of Brent’s views on Linked servers and asking if the application could open a connection to Postgres directly. I would create a stored procedure, move the query to the stored ...
bd_iii's user avatar
  • 97

Top 50 recent answers are included