We're switching over from Oracle to PostgreSQL, and apologies in advance if this is too newbie a question, but can we write a trigger in Posgres to record user logon for audit purposes? I'd thought there would be some "after/before logon trigger" that'll achieve this, but I've been googling around to no avail.
