I am studying ways to implement audit tables to my PostgreSQL database and would like to know if it is possible to make a trigger for the data to be written to a table in a database other than the source database.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You can do that with the help of the additional module
You need superuser privileges (in the database cluster where the trigger runs) for some of the involved functionality.
Since you want to write to the external database, you will probably want to use
Note that you cannot