Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - UUID

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - UUID
Syntax UUID
Data Universally unique identifier
Version Differences PostgreSQL 8.3 and later - UUID data type is available
Storage Size 16 bytes
Standards PostgreSQL Extension

An example of UUID:


PostgreSQL UUID - Equivalents in Other Databases

Database Data Type and Conversion
Sybase ASE CHAR(32) for UUID values without dashes, or CHAR(36) for UUID values with dashes; NEWID() function can be used to generate UUID values

All Data Types

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.