Functions / System Administration Functions

pg_database_collation_actual_version

Returns the actual version of the database's collation as it is currently installed in the operating system.

Reading PG 18current·documented in 6 of 27 versions, 15 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_database_collation_actual_version ( oid ) → text

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.

Version history 1

14 → 15 added

Definition snapshot: b7bd9cda · English manual source