pg_collation_actual_version()

A function returning the actual version of the collation object

pg_collation_actual_version() is a system function returning the actual version of the collation object as currently installed in the operating system.

pg_collation_actual_version() was added in PostgreSQL 10.

Usage

pg_collation_actual_version ( oid ) → text

If the version returned by this function is different from the value in the collversion column in pg_collation, then objects depending on the collation might need to be rebuilt using ALTER COLLATION ... REFRESH VERSION.

Change history

Examples

Usage example for pg_collation_actual_version():

postgres=# CREATE TABLE foo (id INT NOT NULL, val TEXT COLLATE "de_DE.utf8");
CREATE TABLE

postgres=# SELECT pg_describe_object(refclassid, refobjid, refobjsubid) AS "Collation",
                  pg_describe_object(classid, objid, objsubid) AS "Object",
                  c.collversion,
pg_collation_actual_version(c.oid) FROM pg_depend d JOIN pg_collation c ON (refclassid = 'pg_collation'::regclass AND refobjid = c.oid) ORDER BY 1, 2; Collation | Object | collversion | pg_collation_actual_version ------------------------+-------------------------+-------------+----------------------------- collation "de_DE.utf8" | column val of table foo | 2.28 | 2.28

Categories

Collation, Locale and character set handling, System function

See also

pg_database_collation_actual_version(), pg_import_system_collations(), ALTER COLLATION