Ispirer Migration Knowledge Base

User Tools

Site Tools

You are here: Ispirer Migration Knowledge Base » Ispirer Migration Knowledge Base » Migration to PostgreSQL » PostgreSQL Data Types » PostgreSQL Data Types - SMALLINT


Ispirer Website Ispirer Capabilities - PostgreSQL Migration Free Trial

PostgreSQL Data Types - SMALLINT

Versions: PostgreSQL 8.x and 7.x

PostgreSQL - SMALLINT
Syntax SMALLINT
Data 16-bit integer data
Range -32768 to 32767
Storage Size 2 bytes
Synonyms INT2
Standards ANSI SQL

PostgreSQL SMALLINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(5,0), -105-1 to 105-1
SQL Server SMALLINT, -32768 to 32767
MySQL SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Sybase ASE SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Informix SMALLINT, -32768 to 32767
HP Neoview SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Ingres SMALLINT, -32768 to 32767; TINYINT, -128 to 127

Related Data Types in PostgreSQL

Data Types
Integers BIGINT INT
Auto-increment integers SERIAL BIGSERIAL
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird Ingres
© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.