creating a trigger to access another postgres database?

From: carty mc <cartymc3(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: creating a trigger to access another postgres database?
Date: 2008-03-28 14:51:28
Message-ID: 30564.58924.qm@web58515.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a question regarding postgres Trigger.
We have two applications which connect to two different databases (Both are postgres).
Is it possible to create a trigger (row based) in one database say A, which can access another database say B and updates a table there.

In brief, Is it possible to create Trigger in one database, which can connect to another database for making an update in the other database table.

thanks,


---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brian 2008-03-28 15:03:42 Re: table of US states' neighbours
Previous Message Tom Lane 2008-03-28 14:50:25 Re: Merge Joins and Views