TINYINT Data Type - SQL Server to PostgreSQL Migration

In SQL Server, the TINYINT data type stores 8-bit integer values from 0 to 255. In PostgreSQL, you can use the SMALLINT data type, a 16-bit data type that can store integers from -32,768 to 32,767.

SQL Server:

  -- Sample table 
  CREATE TABLE specs
  (
    item VARCHAR(30),
    cnt TINYINT
  );

PostgreSQL:

  -- Sample table 
  CREATE TABLE specs
  (
    item VARCHAR(30),
    cnt SMALLINT
  );

For more information, see SQL Server to PostgreSQL Migration.