Is there any way to achieve autonomous transactions in Postgres? There is a way to do it by using DB Link. However DB Link involves user name and password which is a bit of a security threat.
How to use certificate based authentication in DB Links instead of hardcoding user name and password in it?
dblink lets you pass in a PostgreSQL connection string[1].
From there you can reference parameters to use certificates[2].
