Re: Post to another db using pl/pgsql

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Post to another db using pl/pgsql
Date: 2008-11-12 17:12:11
Message-ID: 3D690C4C-25DD-44E7-81CF-7E3A2E7A69F6@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 12, 2008, at 8:55 AM, Robert Fitzpatrick wrote:

> I've worked with pgsql for a while, but never needed to post from a
> database trigger to another db. Is this possible? And if so, can
> someone
> offer a pointer to the docs on how to refer to other db's in my
> script,
> etc?

Look for dblink (if it's another postgresql database) or dbilink (if
it isn't).

dblink is documented in one of the appendices of the postgresql
manual.

Cheers,
Steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2008-11-12 17:36:45 Re: Upgrade in Place
Previous Message Teodor Sigaev 2008-11-12 17:12:00 Re: still gin index creation takes forever