Re: function accessing other db - Mailing list pgsql-novice

From CoL
Subject Re: function accessing other db
Date
Msg-id c0g1gg$21gl$1@news.hub.org
Whole thread Raw
In response to function accessing other db  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Responses concurrent cursors possible with portals?  ("M. Bastin" <marcbastin@mindspring.com>)
List pgsql-novice
Hi,

Marcus Andree S. Magalhaes wrote:

> Hello everyone,
>
> We have to copy some data from one table to another table in other database.
>
> Is there any way to do this from inside a custom plpgsql function, with no
> external applications, interfaces or storage?
>
> Any help is appreciated.

use dblink from contrib.

C.

pgsql-novice by date:

Previous
From: Nick Tew
Date:
Subject: Send email when new record inserted
Next
From: Lynn.Tilby@asu.edu
Date:
Subject: Fwd: Fwd: Lots of nan's