2

I have an application that is directly connected to Postgresql database, I need to retrieve certain values from an external SQL Server database.

Is there a way I can send a select statement to SQL Server from postgresql, and get back the results?

Improve this question
1
  • PostgreSQL and pgAdmin are different thing. Please fix your title if your question is not about pgAdmin. Commented Oct 11, 2022 at 16:33

1 Answer 1

Reset to default
1

yes - you can use foreign table on MS SQL Server

https://www.mssqltips.com/sqlservertip/3663/sql-server-and-postgresql-foreign-data-wrapper-configuration-part-3/

https://github.com/tds-fdw/tds_fdw

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.