update data in different database

From: "Henriksen, Jonas F" <jonas(dot)f(dot)henriksen(at)imr(dot)no>
To: <pgsql-general(at)postgresql(dot)org>
Subject: update data in different database
Date: 2004-10-27 11:42:40
Message-ID: 1612616523F26F48AB55BC8F5D47917C03CBD253@post2.imr.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

is it possible to write a trigger, using pl/pgSQL, that updates tables in a different database than the one the trigger is called from? If it is, what is the syntax for calling the other database? My to databases are on the same server.

Regards Jonas:))

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Hallgren 2004-10-27 11:55:35 Re: Bug or stupidity
Previous Message f-f 2004-10-27 09:41:17