Translates a textual role name to its OID. A similar result is obtained by casting the string to type regrole (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.
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
regrole (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.to_regrole ( text ) → regrole → regroleTranslates a textual role name to its OID. A similar result is obtained by casting the string to type
regrole (see Section 8.19); however, this function will return NULL rather than throwing an error if the name is not found.{"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:99006a55225670eed5e683ac27e0608db2b76a73b50fd135e8e86317f3a09650
Text language: en · wiki-repair-20261023:99006a55225670eed5e683ac27e0608db2b76a73b50fd135e8e86317f3a09650