Data type conversion table: Informix to PostgreSQL

Table 1. Data type conversion table (Informix to PostgreSQL)
Informix® data types	PostgreSQL data types (since 8.4)
`CHAR(n)`	`CHAR(n)`
`VARCHAR(n[,m])`	`VARCHAR(n)`
`LVARCHAR(n[,m])`	`VARCHAR(n)`
`NCHAR(n)`	N/A
`NVARCHAR(n[,m])`	N/A
`BOOLEAN`	`BOOLEAN`
`SMALLINT`	`INT2`
`INTEGER`	`INT4`
`BIGINT`	`BIGINT`
`INT8`	`BIGINT`
`SERIAL[(start)]`	`INTEGER` (see note 1)
`BIGSERIAL[(start)]`	`BIGINT` (see note 1)
`SERIAL8[(start)]`	`BIGINT` (see note 1)
`DOUBLE PRECISION / FLOAT[(n)]`	`FLOAT4`
`REAL / SMALLFLOAT`	`FLOAT8`
`DECIMAL(p,s)`	`DECIMAL(p,s)`
`DECIMAL(p)`	`DECIMAL` (no precision = floating point)
`DECIMAL`	`DECIMAL` (no precision = floating point)
`MONEY(p,s)`	`DECIMAL(p,s)`
`MONEY(p)`	`DECIMAL(p,2)`
`MONEY`	`DECIMAL(16,2)`
`DATE`	`DATE`
`DATETIME HOUR TO MINUTE`	`TIME(0) WITHOUT TIME ZONE`
`DATETIME HOUR TO SECOND`	`TIME(0) WITHOUT TIME ZONE`
`DATETIME HOUR TO FRACTION(p)`	`TIME(p) WITHOUT TIME ZONE`
`DATETIME YEAR TO MINUTE`	`TIMESTAMP(0) WITHOUT TIME ZONE`
`DATETIME YEAR TO SECOND`	`TIMESTAMP(0) WITHOUT TIME ZONE`
`DATETIME YEAR TO FRACTION(p)`	`TIMESTAMP(p) WITHOUT TIME ZONE`
`DATETIME q1 TO q2 (other than above)`	`TIMESTAMP(p) WITHOUT TIME ZONE`
`INTERVAL YEAR[(p)] TO MONTH`	`INTERVAL YEAR TO MONTH`
`INTERVAL YEAR[(p)] TO YEAR`	`INTERVAL YEAR`
`INTERVAL MONTH[(p)] TO MONTH`	`INTERVAL MONTH`
`INTERVAL DAY[(p)] TO FRACTION(n)`	`INTERVAL DAY TO SECOND(n)`
`INTERVAL DAY[(p)] TO SECOND`	`INTERVAL DAY TO SECOND(0)`
`INTERVAL DAY[(p)] TO MINUTE`	`INTERVAL DAY TO MINUTE`
`INTERVAL DAY[(p)] TO HOUR`	`INTERVAL DAY TO HOUR`
`INTERVAL DAY[(p)] TO DAY`	`INTERVAL DAY`
`INTERVAL HOUR[(p)] TO FRACTION(n)`	`INTERVAL HOUR TO SECOND(n)`
`INTERVAL HOUR[(p)] TO SECOND`	`INTERVAL HOUR TO SECOND(0)`
`INTERVAL HOUR[(p)] TO MINUTE`	`INTERVAL HOUR TO MINUTE`
`INTERVAL HOUR[(p)] TO HOUR`	`INTERVAL HOUR`
`INTERVAL MINUTE[(p)] TO FRACTION(n)`	`INTERVAL MINUTE TO SECOND(n)`
`INTERVAL MINUTE[(p)] TO SECOND`	`INTERVAL MINUTE TO SECOND(0)`
`INTERVAL MINUTE[(p)] TO MINUTE`	`INTERVAL MINUTE`
`INTERVAL SECOND[(p)] TO FRACTION(n)`	`INTERVAL SECOND(n)`
`INTERVAL SECOND[(p)] TO SECOND`	`INTERVAL SECOND(0)`
`INTERVAL FRACTION[(p)] TO FRACTION(n)`	`INTERVAL SECOND(n)`
`TEXT`	`TEXT`
`BYTE`	`BYTEA`

Notes:

For more details about serial emulation, see SERIAL data types.