uuid_version()

Extract the version of a UUID

Since 2.13.0

Extract the version number from a UUID object:

Samples

postgres=# SELECT uuid_version('019913ce-f124-7835-96c7-a2df691caa98');

Returns something like:

 uuid_version
--------------
            7

Arguments

The syntax is:

SELECT uuid_version(
    uuid = <uuid>
);

Name	Type	Default	Required	Description
uuid	UUID	-	✔	The UUID object to extract the version number from

Returns

Column	Type	Description
uuid_version	INTEGER	The version number extracted from the UUID object (e.g., 7 for UUIDv7).