Parent topic: Data dictionary
SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Data dictionary

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.

Parent topic: Data dictionary