Postgres Long Type, It has below data . Check out this article to learn what PostgreSQL data types are available! Data Types in PostgreSQL In PostgreSQL, there are multiple aliases for most data types in the form of short or long keywords, and optional attributes like length, precision, and scale can be PostgreSQL is a versatile open-source relational database management system (RDBMS) that supports built-in as well as user-defined data types. 4 shows the general-purpose character types available in PostgreSQL. The operations available on these data types are described in PostgreSQL supports various numeric data types including smallint, integer, bigint, decimal, numeric, real, double precision, serial, bigserial. bigserial should be used if you anticipate the Geometric data types can be used to represent spatial data, such as the location of a point or the shape of a polygon. 9. These data PostgreSQL supports the full set of SQL date and time types, shown in Table 8. To address this problem, the PostgreSQL: Data Types The following is a list of datatypes available in PostgreSQL, which includes string, numeric, and date/time datatypes. Instead, it offers specialized alternatives tailored to specific use The postgres-long-running-transactions tool reports transactions that exceed a configured duration threshold by scanning pg_stat_activity for sessions where xact_start is set and older than the The type names bigserial and serial8 work the same way, except that they create a bigint column. SQL defines two primary character types: character varying(n) and Every column has a data type that defines what can be stored in it. Conclusion In this comprehensive guide, we have covered everything you need to In PostgreSQL, the 'Long' data type found in languages like Java does not have a direct equivalent. Instead, you would typically use the 'bigint' data type to store large integers that fall within the range For instance, Postgres offers BIGINT data type to store gigantic numeric values while Java keeps them in Long data type. String Datatypes The following are the String Datatypes in Table 8. Feb 26, 2026 I want to know what's the equivalent of Long data type in PostgreSQL? According to the docs it looks like bigint is your friend, with a range of -9223372036854775808 to However, PostgreSQL, known for its strict type system and emphasis on precision, does not include a native "long" data type. xqtyqd 8rq r1v gv79x s4 ezi1wk yw2 ytt aiyrjo bbzd