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 you have read our privacy policy.

Browse other questions tagged or ask your own question.