SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
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 |
SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
Discussion