PostgreSQL INT, INTEGER Data Type - Features, Examples and Equivalents

INT data type stores 32-bit integer data.

Versions: PostgreSQL 9.x and 8.x

Related data types for INT/INTEGER in PostgreSQL:

INT/INTEGER data type in other databases:

Oracle:

SQL Server:

MySQL:

Conversion of INT/INTEGER data type:

PostgreSQL:

  CREATE TABLE t_int1
  (
     c1 INT,
     c2 INTEGER,
     c3 INT4
  );

Oracle:

Oracle supports INT/INTEGER data type for compatibility with ANSI/ISO SQL, but it is converted to NUMBER(38) that can store up to 38 digits and significantly exceeds 32-bit range for ANSI/ISO INTEGER.

To preserve INTEGER range, you can convert it to NUMBER(10, 0):

  CREATE TABLE t_int1
  (
     c1 NUMBER(10, 0),
     c2 NUMBER(10, 0),
     c3 NUMBER(10, 0)
  );

SQL Server

SQL Server supports INT/INTEGER data types but does not support their synonym INT4 that needs to be converted:

  CREATE TABLE t_int1
  (
     c1 INT,
     c2 INTEGER,
     c3 INT
  );

MySQL:

MySQL supports INT/INTEGER data types including synonym INT4, so no any conversion is required:

  CREATE TABLE t_int1
  (
     c1 INT,
     c2 INTEGER,
     c3 INT4
  );

• PostgreSQL Reference
• http://www.postgresql.org/docs/9.1/static/datatype-numeric.html