Postgres View with content from another Databaseserver Is it somehow possible to create a view on a Postgres database which gets its original data from a table of a SQL Server database on another server?

I want to have the data from a table of the SQL Server database on server A inside a table on my Postgres database on server B, but I can't use export import, also no scripted solution because I need them nearly realtime.
You can use a FDW1 to connection on your MSSQL database and get your data. A FDW expose a remote service (a database, webservice, api, etc) like a table for read and write.

For MSSQL, the tds_fdw2can do the trick.

Let me know if you need a example or more details how the FDW work.

References:


https://wiki.postgresql.org/wiki/Foreign_data_wrappers
http://pgxn.org/dist/tds_fdw/