AFTER LOGON(Oracle) trigger in PostgreSQL with extension – login_hook

Before going into the details, thanks to the author of ‘login hook’ extension for developing and maintaining it. Many times, in Oracle to Postgres migration exercise, I have seen the use of Oracle Database Event trigger – AFTER LOGON ON. Its one type of Oracle database/user event trigger(LOGON) that fires when a user connects to…