Search PostgreSQL documentation

jsonbData TypesPG18jsonb binary JSON data, decomposedData Types anyData TypesPG18any Indicates that a function accepts any input data type.Pseudo-Types anyarrayData TypesPG18anyarray Indicates that a function accepts any array data type (see Section 36.2.5).Pseudo-Types anycompatibleData TypesPG18anycompatible Indicates that a function accepts any data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblearrayData TypesPG18anycompatiblearray Indicates that a function accepts any array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblemultirangeData TypesPG18anycompatiblemultirange Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17)…Pseudo-Types anycompatiblenonarrayData TypesPG18anycompatiblenonarray Indicates that a function accepts any non-array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5).Pseudo-Types anycompatiblerangeData TypesPG18anycompatiblerange Indicates that a function accepts any range data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17).Pseudo-Types anyelementData TypesPG18anyelement Indicates that a function accepts any data type (see Section 36.2.5).Pseudo-Types anyenumData TypesPG18anyenum Indicates that a function accepts any enum data type (see Section 36.2.5 and Section 8.7).Pseudo-Types anymultirangeData TypesPG18anymultirange Indicates that a function accepts any multirange data type (see Section 36.2.5 and Section 8.17).Pseudo-Types anynonarrayData TypesPG18anynonarray Indicates that a function accepts any non-array data type (see Section 36.2.5).Pseudo-Types anyrangeData TypesPG18anyrange Indicates that a function accepts any range data type (see Section 36.2.5 and Section 8.17).Pseudo-Types bigintData TypesPG18bigint int8 signed eight-byte integerData Types bigserialData TypesPG18bigserial serial8 autoincrementing eight-byte integerData Types bitData TypesPG18bit [ (n) ] fixed-length bit stringData Types bit varyingData TypesPG18bit varying [ (n) ] varbit [ (n) ] variable-length bit stringData Types booleanData TypesPG18boolean bool logical Boolean (true/false)Data Types boxData TypesPG18box rectangular box on a planeData Types byteaData TypesPG18bytea binary data (“byte array”)Data Types characterData TypesPG18character [ (n) ] char [ (n) ] fixed-length character stringData Types character varyingData TypesPG18character varying [ (n) ] varchar [ (n) ] variable-length character stringData Types cidrData TypesPG18cidr IPv4 or IPv6 network addressData Types circleData TypesPG18circle circle on a planeData Types cstringData TypesPG18cstring Indicates that a function accepts or returns a null-terminated C string.Pseudo-Types dateData TypesPG18date calendar date (year, month, day)Data Types datemultirangeData TypesPG18daterange — Range of date, datemultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types daterangeData TypesPG18daterange — Range of date, datemultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types double precisionData TypesPG18double precision float, float8 double precision floating-point number (8 bytes)Data Types event_triggerData TypesPG18event_trigger An event trigger function is declared to return event_trigger.Pseudo-Types fdw_handlerData TypesPG18fdw_handler A foreign-data wrapper handler is declared to return fdw_handler.Pseudo-Types index_am_handlerData TypesPG18index_am_handler An index access method handler is declared to return index_am_handler.Pseudo-Types inetData TypesPG18inet IPv4 or IPv6 host addressData Types int4multirangeData TypesPG18int4range — Range of integer, int4multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int4rangeData TypesPG18int4range — Range of integer, int4multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int8multirangeData TypesPG18int8range — Range of bigint, int8multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types int8rangeData TypesPG18int8range — Range of bigint, int8multirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types integerData TypesPG18integer int, int4 signed four-byte integerData Types internalData TypesPG18internal Indicates that a function accepts or returns a server-internal data type.Pseudo-Types intervalData TypesPG18interval [ fields ] [ (p) ] time spanData Types