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

This would work if both tables (tablea and tableb) resides on the
same database. What to do if, say tablea lives on database 'db1' and
tableb resides on another database, 'db2' ?

 Thanks for your message.


> 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;