Re: update data in different database

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Henriksen, Jonas F" <jonas(dot)f(dot)henriksen(at)imr(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: update data in different database
Date: 2004-10-27 12:20:23
Message-ID: 417F9287.3090308@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carlos 2004-10-27 12:23:17 Changing access permissions without re-starting the database
Previous Message Karsten Hilbert 2004-10-27 12:04:27 Re: update data in different database