Re: update data in different database - Mailing list pgsql-general

From Richard Huxton
Subject Re: update data in different database
Date
Msg-id 417F9287.3090308@archonet.com
Whole thread Raw
In response to update data in different database  ("Henriksen, Jonas F" <jonas.f.henriksen@imr.no>)
List pgsql-general
Henriksen, Jonas F wrote:
> 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.

Look into the dblink package in the contrib directory of the source
distribution (or your contrib package)

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: update data in different database
Next
From: Carlos
Date:
Subject: Changing access permissions without re-starting the database