Re: Post to another db using pl/pgsql - Mailing list pgsql-general

From Steve Atkins
Subject Re: Post to another db using pl/pgsql
Date
Msg-id 3D690C4C-25DD-44E7-81CF-7E3A2E7A69F6@blighty.com
Whole thread Raw
In response to Post to another db using pl/pgsql  (Robert Fitzpatrick <lists@webtent.net>)
List 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


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Table bloat and vacuum
Next
From: Naomi Walker
Date:
Subject: Upgrade in Place