Postgres Pro
Downloads
Home   >   mailing lists

Update PostgreSQL from MS SQL trigger - Mailing list pgsql-sql

From Igor Kryltsov
Subject Update PostgreSQL from MS SQL trigger
Date
Msg-id d0jar6$14rh$1@news.hub.org
Whole thread Raw
List pgsql-sql
Tree view 
Hi,

I have table 'test_m'(id integer) in MSSQL and I want to write
on_test_m_insert trigger in MS SQL which will insert value into PostgreSQL
table 'test_p' from database 'test_db' running on host '10.3.2.5'.

Can this be achieved with PostgreSQL ODBC driver? If yes, please post
template of such trigger.


Thank you,


Igor

pgsql-sql by date:

Previous
From: Bernard Grosperrin
Date:
Subject: Newbie wonder...
Next
From: "Fatih Cerit"
Date:
Subject: plpgsql & date-time functions