From 132e78af46a1fd21068cf795f4427f57c19e356a Mon Sep 17 00:00:00 2001 From: Andrew Alsup Date: Wed, 26 Feb 2025 22:00:14 -0500 Subject: [PATCH v3 2/2] docs for UUID datatype mention UUID versions --- doc/src/sgml/datatype.sgml | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 87679dc4a11..09309ba0390 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -4407,6 +4407,15 @@ SELECT to_tsvector( 'postgraduate' ), to_tsquery( 'postgres:*' ); are only unique within a single database. + + RFC 9562 defines 8 different UUID versions. Each version has specific requirements + for generating new UUID values, and each version provides distinct benefits and drawbacks. + PostgreSQL provides native support for generating UUIDs + using the UUIDv4 and UUIDv7 algorithms. Alternatively, UUID values can be generated + outside of the database using any algorithm. The data type uuid can be used + to store any UUID, regardless of the origin and the UUID version. + + A UUID is written as a sequence of lower-case hexadecimal digits, in several groups separated by hyphens, specifically a group of 8 -- 2.39.5 (Apple Git-154)