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