Postgres View with content from another Databaseserver
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/