The Basics Of PostgreSQL UUID Data Type
Summary : in this tutorial, you will learn about the PostgreSQL UUID data type and how to generate UUID values using a supplied module. Introduction to PostgreSQL UUID type UUID stands for Universal Unique Identifier defined by RFC 4122 and other related standards. A UUID value is 128-bit quantity generated by an algorithm that make it unique in the known universe using the same algorithm. The following shows some examples of the UUID values: 1 2 3 40e6215d - b5c6 - 4896 - 987c - f30f3678f608 6ecd8c99 - 4036 - 403d - bf84 - cf8400f67836 3f333df6 - 90a4 - 4fda - 8dd3 - 9485d27cee36 As you can see, a UUID is a sequence of 32 digits of hexadecimal digits represented in groups separated by hyphens. Because of its uniqueness feature, you often found UUID in the distributed systems because it guarantees a better uniqueness than the SERIAL data type which generates only unique values within a single database. To stores UUID val...