PostgreSQL Data Types - BYTEA

Versions: PostgreSQL 8.x and 7.x

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