Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2011

    Unanswered: getting data from MS sql using trigger procedure

    Hi all

    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?


  2. #2
    Join Date
    Mar 2014
    Try DBLink

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts