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

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