Unanswered: getting data from MS sql using trigger procedure
I would like to be able to update my postgres database with information from a table located in a MS sql 2008R2 database using a trigger procedure (INSERT).
When one of our users update (insert) information in the postgres database the trigger should be activated, looking up in a table in the MS sql database and updating some of the columns in the postgres table.
How is that possible? Can someone point to an example we can use? We´re using postgres 8.4, so as far as I know its not possible to use foreign data wrappers?