Insert into other database

From: Rodolfo Campos <camposer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Insert into other database
Date: 2006-02-08 21:59:19
Message-ID: 140c63030602081359p68ec152dr7e03f6a6e78ff978@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-02-08 22:20:57 Re: Insert into other database
Previous Message Merlin Moncure 2006-02-08 21:42:42 Re: Is there a way to limit CPU usage per user