uuid_version()

Extract the version of a UUID

Community

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