Re: function accessing other db

On Thu, Feb 12, 2004 at 11:43:11 -0200,
"Marcus Andree S. Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br> 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?

You can do something like:

INSERT INTO tablea (col1, col2, col3) SELECT col1, col2, col3 FROM tableb;