Linked Postgres Server ON MS SQL 2005

Question

Hi All

I have a linked server configured for a Postgres server on my MS SQL 2005 server. I use this server quite often to receive data for queries and reports but the server response is to slow and need an alternative solution. The ODBC provider I'm using is PGNP on the linked server. I thought of using openrowset so I could only return the data I need but not sure how to specify the IP Address, Port number, username or password. Please could anyone help. To query the linked server currently I use SELECT * FROM [LinkedServer].[DatabaseName].[Public].[tablename] WHERE (Statement)

Answer 1

0

You would use something along these lines:

SELECT * FROM OPENROWSET('ProviderName', 'ConnectionString', 
                         'SELECT * FROM [DatabaseName].[Public].[tablename] 
                          WHERE (Statement)')

You then would need to substitute ProviderName and ConnectionString with the relevant details for your PostGres client. I am not sure what they are though. However, this page has some good examples.

answered Sep 21 '10 at 06:17 AM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

(comments are locked)

Linked Postgres Server ON MS SQL 2005

Follow this question

Related Questions