Update PostgreSQL from MS SQL trigger

From: "Igor Kryltsov" <kryltsov(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Update PostgreSQL from MS SQL trigger
Date: 2005-03-08 04:47:57
Message-ID: d0jar6$14rh$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2005-03-08 07:06:02 Re: SQL query help?
Previous Message Keith Worthington 2005-03-08 04:36:40 Re: SQL query help?