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 MONTH TIMESTAMP(0) WITHOUT TIME ZONE
DATETIME YEAR TO DAY TIMESTAMP(0) WITHOUT TIME ZONE
DATETIME YEAR TO HOUR TIMESTAMP(0) 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
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:
  1. For more details about serial emulation, see SERIAL and BIGSERIAL data types.