9.14. UUID Functions

Development Versions: devel

Table 9.45 shows the PostgreSQL functions that can be used to generate UUIDs.

Table 9.45. UUID Generation Functions

Function Description Example(s)
`gen_random_uuid` ( ) → `uuid` `uuidv4` ( ) → `uuid` Generates a version 4 (random) UUID `gen_random_uuid()` → `5b30857f-0bfa-48b5-ac0b-5c64e28078d1` `uuidv4()` → `b42410ee-132f-42ee-9e4f-09a6485c95b8`
`uuidv7` ( [ `shift` `interval` ] ) → `uuid` Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter `shift` will shift the computed timestamp by the given `interval`. `uuidv7()` → `019535d9-3df7-79fb-b466-fa907fa17f9e`

Function

Description

Example(s)

gen_random_uuid ( ) → uuid

uuidv4 ( ) → uuid

Generates a version 4 (random) UUID

gen_random_uuid() → 5b30857f-0bfa-48b5-ac0b-5c64e28078d1

uuidv4() → b42410ee-132f-42ee-9e4f-09a6485c95b8

uuidv7 ( [ shift interval ] ) → uuid

Generates a version 7 (time-ordered) UUID. The timestamp is computed using UNIX timestamp with millisecond precision + sub-millisecond timestamp + random. The optional parameter shift will shift the computed timestamp by the given interval.

uuidv7() → 019535d9-3df7-79fb-b466-fa907fa17f9e

Note

The uuid-ossp module provides additional functions that implement other standard algorithms for generating UUIDs.

Table 9.46 shows the PostgreSQL functions that can be used to extract information from UUIDs.

PostgreSQL also provides the usual comparison operators shown in Table 9.1 for UUIDs.

See Section 8.12 for details on the data type uuid in PostgreSQL.