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