UUID, Bytea, and Bitstring

Learn about universally unique identifiers, bytea, and bitstring

Universally unique identifier: UUID

A Universally Unique Identifier (UUID) is a 128-bit number used to identify information in computer systems. The term Globally Unique Identifier (GUID) is also used. PostgreSQL implements support for UUID, both for storing and processing them and also with the uuid-ossp extension for generating them.

The UUID extension

If we need to generate UUIDs from PostgreSQL, then we have to install the extension. The extension is part of the PostgreSQL contribs, so we need to have that OS package installed.

Get hands-on with 1200+ tech skills courses.