Returns the actual version of the database's collation as it is currently installed in the operating system. If this is different from the value in pg_database.datcollversion, then objects depending on the collation might need to be rebuilt. See also ALTER DATABASE.
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
pg_database.datcollversion, then objects depending on the collation might need to be rebuilt. See also ALTER DATABASE.pg_database_collation_actual_version ( oid ) → text → textReturns the actual version of the database's collation as it is currently installed in the operating system. If this is different from the value in
pg_database.datcollversion, then objects depending on the collation might need to be rebuilt. See also ALTER DATABASE.{"inputs":[{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"885561d57facd49c33b44a50e320a002197d700d118784cc87d6410efadbd1f6","version":"18.7"},{"file":"functions-admin.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"830e894d29fec30b7c350c915fcaed4a63b24d57f2c96150bf25fa07fb43849c","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:ddfea667fbf3d8ea487e1d668dc68e902cc05b60d310d904f7d4828578d0fad2
Text language: en · wiki-repair-20261023:ddfea667fbf3d8ea487e1d668dc68e902cc05b60d310d904f7d4828578d0fad2