Psql integer max

Name, Storage Size, Description, Range. INTis an alias for the INTEGER data type. Integer ( INT ) is a 4-byte integer that has a range from -14486to 1448647. INT data type stores 32-bit integer data.

Syntax INT or INTEGER Quick Example CREATE TABLE t (c INT); Range -2to 231-(Gb) Storage Size bytes . Generally, GiST may be a good choice for the range fields and HStoreField. The growth rate of this . Any two non-negative integers can be use separated by a single underscore. This type is mapped to Ruby Range objects. Display range of integer ; int8range — Display range of bigint . IOException: Tried to send an out-of- range integer as a 2-byte value: 1000at . EDB Postgres Advanced Server v11: EDB Postgres Advanced Server (EPAS) builds. Signed integer , Alias for INTEGER.

PostgreSQL offers a rich set of native data types for users.