Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Migration to PostgreSQL Request SQLWays

sqlways/postgresql/data-types/uuid.txt · Last modified: May 07, 2018, 03:15:32 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement