Insert into other database - Mailing list pgsql-general

From Rodolfo Campos
Subject Insert into other database
Date
Msg-id 140c63030602081359p68ec152dr7e03f6a6e78ff978@mail.gmail.com
Whole thread Raw
Responses Re: Insert into other database  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Hi Fellows,

I'm wondering if in postgres we can insert a tuple into a table that is outside of a database (I'm supossed to be connected to database1 and want to insert a register into a table in database2).

This question is because I want to update a tables into one database from a trigger (written in C), and the table who fires the trigger is in another database.

I'm making the connection with SPI_connect. What can I do?? Is this posible??

Thanks in advance,

Rodolfo Campos.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Is there a way to limit CPU usage per user
Next
From: Michael Fuhr
Date:
Subject: Re: Insert into other database