CODEWITHSUNDEEP
sql-serverpostgresql
tapiwajemwa
tapiwajemwa

Reputation: 21

Is there a way of accessing SQL Server database directly from PostgreSQL(PgAdmin)?

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?

Upvotes: 2

Views: 622

Answers (1)

Pavel Stehule
Pavel Stehule

Reputation: 45835

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

Upvotes: 1

Related Questions