How to get last modified timestamp of password change for user in postgresql. I searched many documents over internet not able to find any pg tables to check the lastmodified password. can someone help me on this.
This isn't a bug so a bug report form isn't the correct place to ask.
But anyway, its my understanding that none of the PostgreSQL catalog tables, including pg_authid, record timestamp information so if you want to use native PostgreSQL stored credentials you will not have this feature. You would need to delegate authentication to a more feature full system.