Help Center/ Data Warehouse Service/ SQL Syntax Reference (9.1.0.x)/ Functions and Operators/ Database Object Functions/ Collation Version Function
Updated on 2025-09-18 GMT+08:00
View PDF

Collation Version Function

pg_collation_actual_version (oid)

Description: Returns the actual version of the collation object currently installed in the operating system. Currently, this parameter is valid only for case_insensitive collations.

Return type: text

Example:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
 
SELECT oid FROM pg_collation WHERE collname ='case_insensitive';
 oid
------
 3300
(1 row)

SELECT pg_collation_actual_version(3300);
 pg_collation_actual_version
-----------------------------
 153.14
(1 row)
Parent Topic: Database Object Functions