SQLWays Product Page - Migration to PostgreSQL
Free Evaluation
Versions: PostgreSQL 8.x and 7.x
| PostgreSQL - BYTEA | |
|---|---|
| Syntax | BYTEA |
| Data | Variable-length binary data |
| Range | 231-1 bytes (2G) |
| Standards | PostgreSQL Extension |
PostgreSQL BYTEA - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | BLOB, 4G |
| SQL Server | VARBINARY(max), 2G, IMAGE, 2G |
| MySQL | VARBINARY(n) - 1 ⇐ n ⇐ 65535; TINYBLOB - 255 bytes; BLOB - 65535 bytes; MEDIUMBLOB - 16M; LONGBLOB - 4G |
| Sybase ASE | IMAGE, 2G |
| Informix | BYTE, 2G, BLOB, 2T |
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