Very large data types

Both Informix® and PostgreSQL Server provide special data types to store very large texts or images:

Table 1. Very large data types (Informix vs. PostgreSQL)
Informix data type PostgreSQL data type
TEXT TEXT
BYTE BYTEA

Solution

TEXT and BYTE data can be stored in PostgreSQL TEXT and BYTEA columns.