Returns the authentication method and the identity (if any) that the user presented during the authentication cycle before they were assigned a database role.
Signatures & examples
system_user → text
Returns the authentication method and the identity (if any) that the user presented during the authentication cycle before they were assigned a database role. It is represented as auth_method:identity or NULL if the user has not been authenticated (for example if Trust authentication has been used).Version history 1