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).
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
auth_method:identity or NULL if the user has not been authenticated (for example if Trust authentication has been used).system_user → text → textReturns 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).{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:a113b83ec69ba1849b1659b4648ae6a1e5c349e9530c8153e6f8222e0a7afd76
Text language: en · wiki-repair-20261023:a113b83ec69ba1849b1659b4648ae6a1e5c349e9530c8153e6f8222e0a7afd76