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:

A0EEBC99-9C0B-4EF8-BB6D-6BB9BD380A11

PostgreSQL UUID - Equivalents in Other Databases

Database	Data Type and Conversion
SQL Server	UNIQUEIDENTIFIER
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

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird