Can I use… bigint (column type)

1. Use int64
2. Accepts character strings (generously cast or not statically typed)

The SQL type bigint is typically no shorter than a 64 big signed integer (-9223372036854775808 to 9223372036854775807).

CREATE TABLE table_name (
   column_name BIGINT
)

Note that the SQL language has no unsigned modifier (see: domain, check).

Related

• Bigint in other places: cast target.

• Other integer types: smallint, integer/int

• Restricting the value range (e.g. unsigned): domain, check

• SQL types for decimal numbers: numeric, decimal, decfloat

• Numeric types with approximate arithmetic: float, real, double precision

• Product specific integer types: tinyint, mediumint, int2, int4, int8, int64, unsigned, signed

Normative References

The type bigint is defined in ISO/IEC 9075:2016-2 (T071, “BIGINT data type”) with an implementation defined precision.0 The corresponding data type of the C programming language is long long,1 which corresponds to the above mentioned value range.2