How to send data to PostgreSQL with MSSQL trigger?

Question

PostgreSQL

It is necessary that when inserting a record into MSSQL, the data is sent to another Postgres database.
How to implement this?

Answer 1

I have never done this in practice, but in theory it is possible to forward a table from MSSQL to PostgreSQL using Foreign_data_wrappers and then use triggers in PostgreSQL.