{"Entry":{"collection":"type","key":"uuid","name":"uuid","aliases":[],"metadata":{"aliases":[],"category":"Other built-in types","content_hash":"2e377abb7878e5e90df32bb04030aa5ba087f890c1e37f9dd2a0222bd11a8c72","derived_content_hash":"e8092ac3b249ed3cfb433425766cd94e031a369dcec0e576e36c9cb7c1c5f928","imported_at":"2026-09-30T00:40:37.044187+08:00","name":"uuid","name_zh":"","slug":"uuid","summary":"universally unique identifier"}},"Definition":{"Collection":"type","Key":"uuid","SourceDatabase":"center","Version":"18","SourceTable":"data_type","SourceKey":"uuid","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":[],"casts":[],"catalog":{"array_type_name":"_uuid","array_type_oid":"2951","descr":"UUID","oid":"2950","typacl":"_null_","typalign":"c","typanalyze":"-","typarray":"0","typbasetype":"0","typbyval":"f","typcategory":"U","typcollation":"0","typdefault":"_null_","typdefaultbin":"_null_","typdelim":"','","typelem":"0","typinput":"uuid_in","typisdefined":"t","typispreferred":"f","typlen":"16","typmodin":"-","typmodout":"-","typname":"uuid","typnamespace":"pg_catalog","typndims":"0","typnotnull":"f","typoutput":"uuid_out","typowner":"POSTGRES","typreceive":"uuid_recv","typrelid":"0","typsend":"uuid_send","typstorage":"p","typsubscript":"-","typtype":"b","typtypmod":"-1"},"comparison_data":{"aliases":[],"casts":[],"catalog":{"array_type_name":"_uuid","typacl":"_null_","typalign":"c","typanalyze":"-","typarray":"_uuid","typbasetype":"0","typbyval":"f","typcategory":"U","typcollation":"0","typdefault":"_null_","typdefaultbin":"_null_","typdelim":",","typelem":"0","typinput":"uuid_in","typisdefined":"t","typispreferred":"f","typlen":"16","typmodin":"-","typmodout":"-","typname":"uuid","typndims":"0","typnotnull":"f","typoutput":"uuid_out","typreceive":"uuid_recv","typrelid":"0","typsend":"uuid_send","typstorage":"p","typsubscript":"-","typtype":"b","typtypmod":"-1"},"facts":[{"label":"Catalog name","value":"pg_catalog.uuid"},{"label":"Declared length","value":"16 bytes"},{"label":"Input function","value":"uuid_in"},{"label":"Output function","value":"uuid_out"},{"label":"Storage strategy","value":"plain"},{"label":"Type OID","value":"2950"},{"label":"Type kind","value":"Base type"}],"operator_classes":[{"opcdefault":"f","opcfamily":"brin/uuid_bloom_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_bloom_ops"},{"opcdefault":"f","opcfamily":"brin/uuid_minmax_multi_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_minmax_multi_ops"},{"opcdefault":"t","opcfamily":"brin/uuid_minmax_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_minmax_ops"},{"opcdefault":"t","opcfamily":"btree/uuid_ops","opcintype":"uuid","opckeytype":"0","opcmethod":"btree","opcname":"uuid_ops"},{"opcdefault":"t","opcfamily":"hash/uuid_ops","opcintype":"uuid","opckeytype":"0","opcmethod":"hash","opcname":"uuid_ops"}],"operators":[{"oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_ge","oprcom":"\u003c=(uuid,uuid)","oprjoin":"scalargejoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003e=","oprnegate":"\u003c(uuid,uuid)","oprrest":"scalargesel","oprresult":"bool","oprright":"uuid"},{"oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_gt","oprcom":"\u003c(uuid,uuid)","oprjoin":"scalargtjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003e","oprnegate":"\u003c=(uuid,uuid)","oprrest":"scalargtsel","oprresult":"bool","oprright":"uuid"},{"oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_le","oprcom":"\u003e=(uuid,uuid)","oprjoin":"scalarlejoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c=","oprnegate":"\u003e(uuid,uuid)","oprrest":"scalarlesel","oprresult":"bool","oprright":"uuid"},{"oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_lt","oprcom":"\u003e(uuid,uuid)","oprjoin":"scalarltjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c","oprnegate":"\u003e=(uuid,uuid)","oprrest":"scalarltsel","oprresult":"bool","oprright":"uuid"},{"oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_ne","oprcom":"\u003c\u003e(uuid,uuid)","oprjoin":"neqjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c\u003e","oprnegate":"=(uuid,uuid)","oprrest":"neqsel","oprresult":"bool","oprright":"uuid"},{"oprcanhash":"t","oprcanmerge":"t","oprcode":"uuid_eq","oprcom":"=(uuid,uuid)","oprjoin":"eqjoinsel","oprkind":"b","oprleft":"uuid","oprname":"=","oprnegate":"\u003c\u003e(uuid,uuid)","oprrest":"eqsel","oprresult":"bool","oprright":"uuid"}],"ranges":[]},"comparison_hash":"92eeb626f952aeee0957eb99aa91848335d0d83b0fd80d41549c4673d1288412","coverage":"source inventory; exact declared input types for operator classes","description":["universally unique identifier"],"description_zh":"通用唯一标识符","description_zh_html":"\u003cp\u003e通用唯一标识符\u003c/p\u003e\u003ch3\u003e同版本中文手册节选\u003c/h3\u003e\u003cp\u003e\n\u003ccode class=\"type\"\u003euuid\u003c/code\u003e 数据类型用于存储由\n    \u003ca class=\"ulink\" href=\"https://datatracker.ietf.org/doc/html/rfc9562\"\u003eRFC 9562\u003c/a\u003e、ISO/IEC 9834-8:2005 及相关标准定义的通用唯一标识符（UUID）。（有些系统把这种数据类型称为全局唯一标识符，或 GUID\u003ca class=\"indexterm\"\u003e\u003c/a\u003e。）这种标识符是一个\n    128 位的量，由某种算法生成，该算法的设计目标是：使已知宇宙中其他人用同一算法生成出相同标识符的概率极低。因此，对于分布式系统而言，这类标识符能比序列生成器提供更好的唯一性保证，因为序列生成器仅在单个数据库内唯一。\n   \u003c/p\u003e\u003cp\u003e\n    RFC 9562 定义了 8 种不同的 UUID 版本。每个版本对生成新 UUID 值都有各自的要求，也各自具备不同的优缺点。\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 原生支持使用 UUIDv4 和\n    UUIDv7 算法生成 UUID。或者，也可以在数据库外部使用任意算法生成\n    UUID 值。\u003ccode class=\"type\"\u003euuid\u003c/code\u003e 数据类型可用于存储任何 UUID，无论其来源和版本为何。\n   \u003c/p\u003e\u003cp\u003e\n    UUID 写作一串小写十六进制数字，并用连字符分隔成若干组：先是 8 位一组，接着是三个 4 位组，最后是一个 12 位组。总共\n    32 个十六进制数字表示 128 个二进制位。标准形式的 UUID\n    例如：\n\u003c/p\u003e\u003cp\u003e\n\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 也接受其他输入形式：可以使用大写字母、用花括号包围标准格式、省略部分或全部连字符，或者在任意\n    4 位分组后额外加上连字符。例如：\n\u003c/p\u003e\u003cp\u003e\u003ca href=\"/zh/docs/18/datatype-uuid.html\"\u003e查看完整中文手册与上下文\u003c/a\u003e。\u003c/p\u003e","facts":[{"label":"Catalog name","value":"pg_catalog.uuid"},{"label":"Type OID","value":"2950"},{"label":"Type kind","value":"Base type"},{"label":"Declared length","value":"16 bytes"},{"label":"Storage strategy","value":"plain"},{"label":"Input function","value":"uuid_in"},{"label":"Output function","value":"uuid_out"}],"facts_zh":[{"label":"目录名称","value":"pg_catalog.uuid"},{"label":"类型 OID","value":"2950"},{"label":"类型种类","value":"基础类型"},{"label":"声明长度","value":"16 字节"},{"label":"存储策略","value":"plain"},{"label":"输入函数","value":"uuid_in"},{"label":"输出函数","value":"uuid_out"}],"manual_documentation":"dedicated family chapter","manual_html":"\u003cdiv class=\"sect1\" id=\"DATATYPE-UUID\"\u003e\n\u003cdiv class=\"titlepage\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch2 class=\"title\"\u003e8.12. UUID Type \u003c/h2\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eThe data type \u003ccode class=\"type\"\u003euuid\u003c/code\u003e stores Universally Unique Identifiers (UUID) as defined by \u003ca class=\"ulink\" href=\"https://datatracker.ietf.org/doc/html/rfc9562\"\u003eRFC 9562\u003c/a\u003e, ISO/IEC 9834-8:2005, and related standards. (Some systems refer to this data type as a globally unique identifier, or GUID, instead.) This identifier is a 128-bit quantity that is generated by an algorithm chosen to make it very unlikely that the same identifier will be generated by anyone else in the known universe using the same algorithm. Therefore, for distributed systems, these identifiers provide a better uniqueness guarantee than sequence generators, which are only unique within a single database.\u003c/p\u003e\n\u003cp\u003eRFC 9562 defines 8 different UUID versions. Each version has specific requirements for generating new UUID values, and each version provides distinct benefits and drawbacks. \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 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 \u003ccode class=\"type\"\u003euuid\u003c/code\u003e can be used to store any UUID, regardless of the origin and the UUID version.\u003c/p\u003e\n\u003cp\u003eA UUID is written as a sequence of lower-case hexadecimal digits, in several groups separated by hyphens, specifically a group of 8 digits followed by three groups of 4 digits followed by a group of 12 digits, for a total of 32 digits representing the 128 bits. An example of a UUID in this standard form is:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003ea0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11\n\u003c/pre\u003e\n\u003cp\u003e\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e also accepts the following alternative forms for input: use of upper-case digits, the standard format surrounded by braces, omitting some or all hyphens, adding a hyphen after any group of four digits. Examples are:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eA0EEBC99-9C0B-4EF8-BB6D-6BB9BD380A11\n{a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11}\na0eebc999c0b4ef8bb6d6bb9bd380a11\na0ee-bc99-9c0b-4ef8-bb6d-6bb9-bd38-0a11\n{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}\n\u003c/pre\u003e\n\u003cp\u003eOutput is always in the standard form.\u003c/p\u003e\n\u003cp\u003eSee \u003ca class=\"xref\" href=\"/docs/18/functions-uuid.html\" title=\"9.14. UUID Functions\"\u003eSection 9.14\u003c/a\u003e for how to generate a UUID in \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e.\u003c/p\u003e\n\u003c/div\u003e","manual_path":"datatype-uuid.html","operator_classes":[{"opcdefault":"t","opcfamily":"btree/uuid_ops","opcintype":"uuid","opckeytype":"0","opcmethod":"btree","opcname":"uuid_ops","opcnamespace":"pg_catalog","opcowner":"POSTGRES"},{"opcdefault":"t","opcfamily":"hash/uuid_ops","opcintype":"uuid","opckeytype":"0","opcmethod":"hash","opcname":"uuid_ops","opcnamespace":"pg_catalog","opcowner":"POSTGRES"},{"opcdefault":"t","opcfamily":"brin/uuid_minmax_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_minmax_ops","opcnamespace":"pg_catalog","opcowner":"POSTGRES"},{"opcdefault":"f","opcfamily":"brin/uuid_minmax_multi_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_minmax_multi_ops","opcnamespace":"pg_catalog","opcowner":"POSTGRES"},{"opcdefault":"f","opcfamily":"brin/uuid_bloom_ops","opcintype":"uuid","opckeytype":"uuid","opcmethod":"brin","opcname":"uuid_bloom_ops","opcnamespace":"pg_catalog","opcowner":"POSTGRES"}],"operators":[{"descr":"equal","oid":"2972","oprcanhash":"t","oprcanmerge":"t","oprcode":"uuid_eq","oprcom":"=(uuid,uuid)","oprjoin":"eqjoinsel","oprkind":"b","oprleft":"uuid","oprname":"=","oprnamespace":"pg_catalog","oprnegate":"\u003c\u003e(uuid,uuid)","oprowner":"POSTGRES","oprrest":"eqsel","oprresult":"bool","oprright":"uuid"},{"descr":"not equal","oid":"2973","oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_ne","oprcom":"\u003c\u003e(uuid,uuid)","oprjoin":"neqjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c\u003e","oprnamespace":"pg_catalog","oprnegate":"=(uuid,uuid)","oprowner":"POSTGRES","oprrest":"neqsel","oprresult":"bool","oprright":"uuid"},{"descr":"less than","oid":"2974","oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_lt","oprcom":"\u003e(uuid,uuid)","oprjoin":"scalarltjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c","oprnamespace":"pg_catalog","oprnegate":"\u003e=(uuid,uuid)","oprowner":"POSTGRES","oprrest":"scalarltsel","oprresult":"bool","oprright":"uuid"},{"descr":"greater than","oid":"2975","oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_gt","oprcom":"\u003c(uuid,uuid)","oprjoin":"scalargtjoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003e","oprnamespace":"pg_catalog","oprnegate":"\u003c=(uuid,uuid)","oprowner":"POSTGRES","oprrest":"scalargtsel","oprresult":"bool","oprright":"uuid"},{"descr":"less than or equal","oid":"2976","oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_le","oprcom":"\u003e=(uuid,uuid)","oprjoin":"scalarlejoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003c=","oprnamespace":"pg_catalog","oprnegate":"\u003e(uuid,uuid)","oprowner":"POSTGRES","oprrest":"scalarlesel","oprresult":"bool","oprright":"uuid"},{"descr":"greater than or equal","oid":"2977","oprcanhash":"f","oprcanmerge":"f","oprcode":"uuid_ge","oprcom":"\u003c=(uuid,uuid)","oprjoin":"scalargejoinsel","oprkind":"b","oprleft":"uuid","oprname":"\u003e=","oprnamespace":"pg_catalog","oprnegate":"\u003c(uuid,uuid)","oprowner":"POSTGRES","oprrest":"scalargesel","oprresult":"bool","oprright":"uuid"}],"ranges":[],"related":[{"label":"pg_type catalog","url":"/wiki/catalog/pg_type/?v=18"},{"label":"pg_cast catalog","url":"/wiki/catalog/pg_cast/?v=18"},{"label":"pg_operator catalog","url":"/wiki/catalog/pg_operator/?v=18"},{"label":"pg_opclass catalog","url":"/wiki/catalog/pg_opclass/?v=18"},{"label":"Arrays","url":"/wiki/type/arrays/?v=18"},{"label":"brin index access method","url":"/wiki/indexam/brin/?v=18"},{"label":"btree index access method","url":"/wiki/indexam/btree/?v=18"},{"label":"hash index access method","url":"/wiki/indexam/hash/?v=18"}],"release":{"channel":"stable","label":"18.6","major":"18","manual_sha256":{"arrays.html":"0e1d5c5a7b4a949d4439995f44f74ad4264e050d16eb9ad2a850fbaee04032df","catalog-pg-type.html":"ea9c9313bab8e92a7da18ebc50c7ff1f908dd80999a7e0ca3bbc82ba626c58d4","datatype-binary.html":"0c03ec47b76e37888a3da7f5dcfd340128a5d356642a85185cc9ebe17856a904","datatype-bit.html":"c49124aad561636c18080b9e09572fde7785a6b9eae86f5a33283f0fd6774c37","datatype-boolean.html":"b633f663e6c8276e7056287640c413aa79dbc15d5353cee0d41653d58d376956","datatype-character.html":"c73eebe413ea709a7792e4cfc3cfe9fb68cb496ebe83c3ebaa9d09f8c40d0f73","datatype-datetime.html":"e366275d8b13845bfa4ef0d68faa093e5f3ecb708a1ec870cbcbf7e425b85699","datatype-enum.html":"cab38e53222e30cc94b24de4b33634fd22d7c93f58ebcf35f646c9b8da78fae8","datatype-geometric.html":"0eb3053cfe7d6b0a4b5592c5d7af8d97cae527e87f063c5793413bcba5c14cd9","datatype-json.html":"650162a05b660146b500a205d523374d00aee117a6a6240d30262be51b6e33e5","datatype-money.html":"8b29c14b90679683ac5c472b59a0a7e2853f32cc7db43fab417b2697a6879964","datatype-net-types.html":"96846e641cc37727ddcd8b8a1aa0dbe33cd9787760a2b4efb0dcb9403d5be63f","datatype-numeric.html":"b74619f7ac2f1ca9f85c48073df78c33dd30e464e61baba6008634534edcb500","datatype-oid.html":"8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38","datatype-pg-lsn.html":"339172f5107cc7eb7139bec911277647219e92a532cebd0f3da0a5dacf8195af","datatype-pseudo.html":"c7cf0b8214304bd8702c95f2142671ae5f0d631f83717f9c07d9e1f2579961b4","datatype-textsearch.html":"4b15e05be8b49a71b28aea22f2c46d0dbf639a91e7b4fe129a4c737c6daad47c","datatype-uuid.html":"292b307b3223c6182bdba687e7f69e6dca9038430143ad79d56327f6ed4c3246","datatype-xml.html":"061fc2295b7b69be704f0a741b8decd10ad721059f871fb0243c669bb54d7822","datatype.html":"e581f67c74e42006289638c8659e9b338adbfd7f068bd8bf2b3be3880fcd2254","domains.html":"82d486973ccc35d14276627a67ac76b434452f23f9ed4d8aa3fbb01fdf285fc2","functions-info.html":"78ac80bf81da2e4f4a33f3b850faa86f0f58ec54a083d6c31da557907de0df87","rangetypes.html":"e4960abc7ce8e51d794f94f1e57b099d30b7f75dd7f2b23a960eef91f6291c33","rowtypes.html":"74f99e029c3a9edfd3e18810ba3c8cb66d3aada91eb67b86476560871e6617e9","sql-createdomain.html":"e94f927196de1b0ea1ce35cd4603c1f6f544439adcc0edf1c4222358e832245b"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_files":{"doc/src/sgml/datatype.sgml":"86328daa77e20d81d222376ec0306d9841a17104e436c08d138eb763aefb3700","src/include/catalog/pg_am.dat":"b3cb86b102a42fb0024cbd99779c9897afb40d12a71f5cc5a0e5aee7ff2f9969","src/include/catalog/pg_am.h":"3426799df799f32163fcc0765f43dbdb5e88e626acf31284fef9fc6014b69d8e","src/include/catalog/pg_cast.dat":"97911281ca2c81917394ccb2ec13367e37c6801fd461d5e1a3d2f28b911b46b2","src/include/catalog/pg_cast.h":"de585c7df687d698e7d1d100dce8a794ac9da52414ea48169191019178c8f053","src/include/catalog/pg_opclass.dat":"4ee7d3619a6aa106e1c0db55de903931c7d11b1c60ba053a022519c55f8ee668","src/include/catalog/pg_opclass.h":"9c218537806c8ef0398302faaca7f91315dfc1198c48706cebffb479b68defaf","src/include/catalog/pg_operator.dat":"5d35b9b2ef5f9797cc815263927ef8a12367fedace53e828b4e8b320e2a7f703","src/include/catalog/pg_operator.h":"621b18cfffe102413d79b746ce7a10f77fc60fdd097bac34c22b31070d3ee3c4","src/include/catalog/pg_opfamily.dat":"3b694879027b858f2ecf1fa1152b7e30c6e15a216ba99c2384291c30e9d52311","src/include/catalog/pg_opfamily.h":"e1f5fc8aebd3042df847455bf66bf755f768c2aa8a9b03d22f7ec8563eba59c0","src/include/catalog/pg_proc.dat":"1f934ce80d460159dda137714374a35f9896315ea2476709cbb4da13b38ef95a","src/include/catalog/pg_proc.h":"f7d59f07c5b95e2f3c7141762a0f576e8a3af7581ba54c27537f4d500472bea5","src/include/catalog/pg_range.dat":"5c2271f8e89e9378d1887204e5785060b77405b5f0ff3e6c719250c9c1dcfcc4","src/include/catalog/pg_range.h":"45546d952b5181f989bd9234721897fc2b37005c8e49ce2ddc156f26974c3ca4","src/include/catalog/pg_type.dat":"5f5887b75677cba2d4a1a0cfeb355df5ed91f85d385fac88bd8d7c605b3578f9","src/include/catalog/pg_type.h":"8fb198749fd82b6c1818a3c18455f226f66116fcfeb3d4959c65ce3fda22802e"},"source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"sections_zh":[],"signature":"uuid","sources":[{"label":"PostgreSQL 18 English manual","path":"datatype-uuid.html","sha256":"292b307b3223c6182bdba687e7f69e6dca9038430143ad79d56327f6ed4c3246","url":"/docs/18/datatype-uuid.html"},{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"tables_zh":[],"zh_from":{"authored_translation":"preserved-translation-of-reverified-type-description","body_sha256":"0b91867dcd512c7ad761cdbb9c703325360c7de5e98abd81cf9139f7bb9b3d05","kind":"same-version-chinese-manual-with-preserved-translation-of-reverified-type-description","manual":{"anchor":"","build_id":107,"extraction":"concept-introduction","fragment_sha256":"aeb798e41b0deb8378eef8344b85f91f1a6fe78aa597aacfa1b3c72902d43694","locale":"zh-Hans","page_key":"datatype-uuid.html","source_hash":"7041e0d4389e8faaf74407ff05177b7a73bbec3fa7ad3de91e946a91b094056b","source_revision":"unknown:rendered-translation-baseline","translated_from_revision":null,"translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","url":"/zh/docs/18/datatype-uuid.html","version":"18"},"runtime_rerun":false,"source_facts_revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","summary_translation":{"english_description_sha256":"3d9ddc4b8b8885a76fda42331469d5b492c25e01607d5353a60f9404ecba5e4e","key":"uuid","kind":"preserved-translation-of-reverified-type-description","localized_description_sha256":"ca018aa72c3ec864e158cd36dc5fe1ce219d54ce473486b185ac4ffbf97070a0","original_localization_sources":[{"language":"zh","matched_nodes":["#DATATYPE-UUID/div[0]","#DATATYPE-UUID/p[2]","#DATATYPE-UUID/p[3]","#DATATYPE-UUID/p[4]","#DATATYPE-UUID/p[8]","#DATATYPE-UUID/p[9]"],"method":"same-major semantic node","sha256":"7069d17b49583a9c54eae2187aa29e86d36e6a65f04b52d259ce4bc6cda64f1f","url":"/docs/18/datatype-uuid.html"}],"source_database":"pgweb","table":"data_type","version":"18"}}},"ManualEvidence":{"manual_path":"datatype-uuid.html","release":{"channel":"stable","label":"18.6","major":"18","manual_sha256":{"arrays.html":"0e1d5c5a7b4a949d4439995f44f74ad4264e050d16eb9ad2a850fbaee04032df","catalog-pg-type.html":"ea9c9313bab8e92a7da18ebc50c7ff1f908dd80999a7e0ca3bbc82ba626c58d4","datatype-binary.html":"0c03ec47b76e37888a3da7f5dcfd340128a5d356642a85185cc9ebe17856a904","datatype-bit.html":"c49124aad561636c18080b9e09572fde7785a6b9eae86f5a33283f0fd6774c37","datatype-boolean.html":"b633f663e6c8276e7056287640c413aa79dbc15d5353cee0d41653d58d376956","datatype-character.html":"c73eebe413ea709a7792e4cfc3cfe9fb68cb496ebe83c3ebaa9d09f8c40d0f73","datatype-datetime.html":"e366275d8b13845bfa4ef0d68faa093e5f3ecb708a1ec870cbcbf7e425b85699","datatype-enum.html":"cab38e53222e30cc94b24de4b33634fd22d7c93f58ebcf35f646c9b8da78fae8","datatype-geometric.html":"0eb3053cfe7d6b0a4b5592c5d7af8d97cae527e87f063c5793413bcba5c14cd9","datatype-json.html":"650162a05b660146b500a205d523374d00aee117a6a6240d30262be51b6e33e5","datatype-money.html":"8b29c14b90679683ac5c472b59a0a7e2853f32cc7db43fab417b2697a6879964","datatype-net-types.html":"96846e641cc37727ddcd8b8a1aa0dbe33cd9787760a2b4efb0dcb9403d5be63f","datatype-numeric.html":"b74619f7ac2f1ca9f85c48073df78c33dd30e464e61baba6008634534edcb500","datatype-oid.html":"8b3360302225f08ae72716ce1804596de95b568e5d31f788cb4597427b28cc38","datatype-pg-lsn.html":"339172f5107cc7eb7139bec911277647219e92a532cebd0f3da0a5dacf8195af","datatype-pseudo.html":"c7cf0b8214304bd8702c95f2142671ae5f0d631f83717f9c07d9e1f2579961b4","datatype-textsearch.html":"4b15e05be8b49a71b28aea22f2c46d0dbf639a91e7b4fe129a4c737c6daad47c","datatype-uuid.html":"292b307b3223c6182bdba687e7f69e6dca9038430143ad79d56327f6ed4c3246","datatype-xml.html":"061fc2295b7b69be704f0a741b8decd10ad721059f871fb0243c669bb54d7822","datatype.html":"e581f67c74e42006289638c8659e9b338adbfd7f068bd8bf2b3be3880fcd2254","domains.html":"82d486973ccc35d14276627a67ac76b434452f23f9ed4d8aa3fbb01fdf285fc2","functions-info.html":"78ac80bf81da2e4f4a33f3b850faa86f0f58ec54a083d6c31da557907de0df87","rangetypes.html":"e4960abc7ce8e51d794f94f1e57b099d30b7f75dd7f2b23a960eef91f6291c33","rowtypes.html":"74f99e029c3a9edfd3e18810ba3c8cb66d3aada91eb67b86476560871e6617e9","sql-createdomain.html":"e94f927196de1b0ea1ce35cd4603c1f6f544439adcc0edf1c4222358e832245b"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_files":{"doc/src/sgml/datatype.sgml":"86328daa77e20d81d222376ec0306d9841a17104e436c08d138eb763aefb3700","src/include/catalog/pg_am.dat":"b3cb86b102a42fb0024cbd99779c9897afb40d12a71f5cc5a0e5aee7ff2f9969","src/include/catalog/pg_am.h":"3426799df799f32163fcc0765f43dbdb5e88e626acf31284fef9fc6014b69d8e","src/include/catalog/pg_cast.dat":"97911281ca2c81917394ccb2ec13367e37c6801fd461d5e1a3d2f28b911b46b2","src/include/catalog/pg_cast.h":"de585c7df687d698e7d1d100dce8a794ac9da52414ea48169191019178c8f053","src/include/catalog/pg_opclass.dat":"4ee7d3619a6aa106e1c0db55de903931c7d11b1c60ba053a022519c55f8ee668","src/include/catalog/pg_opclass.h":"9c218537806c8ef0398302faaca7f91315dfc1198c48706cebffb479b68defaf","src/include/catalog/pg_operator.dat":"5d35b9b2ef5f9797cc815263927ef8a12367fedace53e828b4e8b320e2a7f703","src/include/catalog/pg_operator.h":"621b18cfffe102413d79b746ce7a10f77fc60fdd097bac34c22b31070d3ee3c4","src/include/catalog/pg_opfamily.dat":"3b694879027b858f2ecf1fa1152b7e30c6e15a216ba99c2384291c30e9d52311","src/include/catalog/pg_opfamily.h":"e1f5fc8aebd3042df847455bf66bf755f768c2aa8a9b03d22f7ec8563eba59c0","src/include/catalog/pg_proc.dat":"1f934ce80d460159dda137714374a35f9896315ea2476709cbb4da13b38ef95a","src/include/catalog/pg_proc.h":"f7d59f07c5b95e2f3c7141762a0f576e8a3af7581ba54c27537f4d500472bea5","src/include/catalog/pg_range.dat":"5c2271f8e89e9378d1887204e5785060b77405b5f0ff3e6c719250c9c1dcfcc4","src/include/catalog/pg_range.h":"45546d952b5181f989bd9234721897fc2b37005c8e49ce2ddc156f26974c3ca4","src/include/catalog/pg_type.dat":"5f5887b75677cba2d4a1a0cfeb355df5ed91f85d385fac88bd8d7c605b3578f9","src/include/catalog/pg_type.h":"8fb198749fd82b6c1818a3c18455f226f66116fcfeb3d4959c65ce3fda22802e"},"source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"PostgreSQL 18 English manual","path":"datatype-uuid.html","sha256":"292b307b3223c6182bdba687e7f69e6dca9038430143ad79d56327f6ed4c3246","url":"/docs/18/datatype-uuid.html"},{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}]},"MeasuredEvidence":{}},"Text":{"Collection":"type","Key":"uuid","SourceDatabase":"center","Version":"18","Locale":"en","Title":"uuid","Summary":"universally unique identifier","BodyHTML":"\u003cdiv id=\"DATATYPE-UUID\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch2\u003e8.12. UUID Type \u003c/h2\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eThe data type \u003ccode\u003euuid\u003c/code\u003e stores Universally Unique Identifiers (UUID) as defined by \u003ca href=\"https://datatracker.ietf.org/doc/html/rfc9562\" rel=\"nofollow\"\u003eRFC 9562\u003c/a\u003e, ISO/IEC 9834-8:2005, and related standards. (Some systems refer to this data type as a globally unique identifier, or GUID, instead.) This identifier is a 128-bit quantity that is generated by an algorithm chosen to make it very unlikely that the same identifier will be generated by anyone else in the known universe using the same algorithm. Therefore, for distributed systems, these identifiers provide a better uniqueness guarantee than sequence generators, which are only unique within a single database.\u003c/p\u003e\n\u003cp\u003eRFC 9562 defines 8 different UUID versions. Each version has specific requirements for generating new UUID values, and each version provides distinct benefits and drawbacks. \u003cspan\u003ePostgreSQL\u003c/span\u003e 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 \u003ccode\u003euuid\u003c/code\u003e can be used to store any UUID, regardless of the origin and the UUID version.\u003c/p\u003e\n\u003cp\u003eA UUID is written as a sequence of lower-case hexadecimal digits, in several groups separated by hyphens, specifically a group of 8 digits followed by three groups of 4 digits followed by a group of 12 digits, for a total of 32 digits representing the 128 bits. An example of a UUID in this standard form is:\u003c/p\u003e\n\u003cpre\u003ea0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11\n\u003c/pre\u003e\n\u003cp\u003e\u003cspan\u003ePostgreSQL\u003c/span\u003e also accepts the following alternative forms for input: use of upper-case digits, the standard format surrounded by braces, omitting some or all hyphens, adding a hyphen after any group of four digits. Examples are:\u003c/p\u003e\n\u003cpre\u003eA0EEBC99-9C0B-4EF8-BB6D-6BB9BD380A11\n{a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11}\na0eebc999c0b4ef8bb6d6bb9bd380a11\na0ee-bc99-9c0b-4ef8-bb6d-6bb9-bd38-0a11\n{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}\n\u003c/pre\u003e\n\u003cp\u003eOutput is always in the standard form.\u003c/p\u003e\n\u003cp\u003eSee \u003ca href=\"/docs/18/functions-uuid.html\" rel=\"nofollow\"\u003eSection 9.14\u003c/a\u003e for how to generate a UUID in \u003cspan\u003ePostgreSQL\u003c/span\u003e.\u003c/p\u003e\n\u003c/div\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"017741deaf5ed2b6bbc2f67e73cc618a9dae86007ec65885738abae2e89e2f4c","Payload":{"description":["universally unique identifier"],"manual_html":"\u003cdiv class=\"sect1\" id=\"DATATYPE-UUID\"\u003e\n\u003cdiv class=\"titlepage\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch2 class=\"title\"\u003e8.12. UUID Type \u003c/h2\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eThe data type \u003ccode class=\"type\"\u003euuid\u003c/code\u003e stores Universally Unique Identifiers (UUID) as defined by \u003ca class=\"ulink\" href=\"https://datatracker.ietf.org/doc/html/rfc9562\"\u003eRFC 9562\u003c/a\u003e, ISO/IEC 9834-8:2005, and related standards. (Some systems refer to this data type as a globally unique identifier, or GUID, instead.) This identifier is a 128-bit quantity that is generated by an algorithm chosen to make it very unlikely that the same identifier will be generated by anyone else in the known universe using the same algorithm. Therefore, for distributed systems, these identifiers provide a better uniqueness guarantee than sequence generators, which are only unique within a single database.\u003c/p\u003e\n\u003cp\u003eRFC 9562 defines 8 different UUID versions. Each version has specific requirements for generating new UUID values, and each version provides distinct benefits and drawbacks. \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 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 \u003ccode class=\"type\"\u003euuid\u003c/code\u003e can be used to store any UUID, regardless of the origin and the UUID version.\u003c/p\u003e\n\u003cp\u003eA UUID is written as a sequence of lower-case hexadecimal digits, in several groups separated by hyphens, specifically a group of 8 digits followed by three groups of 4 digits followed by a group of 12 digits, for a total of 32 digits representing the 128 bits. An example of a UUID in this standard form is:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003ea0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11\n\u003c/pre\u003e\n\u003cp\u003e\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e also accepts the following alternative forms for input: use of upper-case digits, the standard format surrounded by braces, omitting some or all hyphens, adding a hyphen after any group of four digits. Examples are:\u003c/p\u003e\n\u003cpre class=\"programlisting\"\u003eA0EEBC99-9C0B-4EF8-BB6D-6BB9BD380A11\n{a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11}\na0eebc999c0b4ef8bb6d6bb9bd380a11\na0ee-bc99-9c0b-4ef8-bb6d-6bb9-bd38-0a11\n{a0eebc99-9c0b4ef8-bb6d6bb9-bd380a11}\n\u003c/pre\u003e\n\u003cp\u003eOutput is always in the standard form.\u003c/p\u003e\n\u003cp\u003eSee \u003ca class=\"xref\" href=\"/docs/18/functions-uuid.html\" title=\"9.14. UUID Functions\"\u003eSection 9.14\u003c/a\u003e for how to generate a UUID in \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e.\u003c/p\u003e\n\u003c/div\u003e","related":[{"label":"pg_type catalog","url":"/wiki/catalog/pg_type/?v=18"},{"label":"pg_cast catalog","url":"/wiki/catalog/pg_cast/?v=18"},{"label":"pg_operator catalog","url":"/wiki/catalog/pg_operator/?v=18"},{"label":"pg_opclass catalog","url":"/wiki/catalog/pg_opclass/?v=18"},{"label":"Arrays","url":"/wiki/type/arrays/?v=18"},{"label":"brin index access method","url":"/wiki/indexam/brin/?v=18"},{"label":"btree index access method","url":"/wiki/indexam/btree/?v=18"},{"label":"hash index access method","url":"/wiki/indexam/hash/?v=18"}],"sections":[]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}