I am creating a software for parking slots reservations in parking buildings. One requirement is to whenever an user logs into the app, his Public IP address should be stored along with his user name and date.

I've created a PL/pgSQL procedure that successfully stores such info on a table, but now I am wondering how to execute that procedure whenever an user connects to the DB? Is there some way to create a Trigger on some Postgres table to do it safely?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.