C.3 pgx_auth_password

The system catalog for storing user-associated password information. Used for password rollover.

Since this catalog contains passwords, it must not be readable by third parties.

Column	Type	References	Description
authpwdroleid	oid	pg_authid.oid	User's identifier (Primary key constraint)
authpwdoldpassword	text		Hashed password Used for authentication when password rollover is enabled.
authpwdoldpasswordsetat	timestamp with time zone		Time at which authpwdoldpassword was set
authpwdnewpassword	text		Hashed password Used for authentication when password rollover is enabled.
authpwdnewpasswordsetat	timestamp with time zone		Time at which authpwdnewpassword was set