Search PostgreSQL documentation

jsonData TypesPG18json textual JSON dataData Types language_handlerData TypesPG18language_handler A procedural language call handler is declared to return language_handler.Pseudo-Types lineData TypesPG18line infinite line on a planeData Types lsegData TypesPG18lseg line segment on a planeData Types macaddrData TypesPG18macaddr MAC (Media Access Control) addressData Types macaddr8Data TypesPG18macaddr8 MAC (Media Access Control) address (EUI-64 format)Data Types moneyData TypesPG18money currency amountData Types numericData TypesPG18numeric [ (p, s) ] decimal [ (p, s) ] exact numeric of selectable precisionData Types nummultirangeData TypesPG18numrange — Range of numeric, nummultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types numrangeData TypesPG18numrange — Range of numeric, nummultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types pathData TypesPG18path geometric path on a planeData Types pg_ddl_commandData TypesPG18pg_ddl_command Identifies a representation of DDL commands that is available to event triggers.Pseudo-Types pg_lsnData TypesPG18pg_lsn PostgreSQL Log Sequence NumberData Types pg_snapshotData TypesPG18pg_snapshot user-level transaction ID snapshotData Types pointData TypesPG18point geometric point on a planeData Types polygonData TypesPG18polygon closed geometric path on a planeData Types realData TypesPG18real float4 single precision floating-point number (4 bytes)Data Types recordData TypesPG18record Identifies a function taking or returning an unspecified row type.Pseudo-Types serialData TypesPG18serial serial4 autoincrementing four-byte integerData Types smallintData TypesPG18smallint int2 signed two-byte integerData Types smallserialData TypesPG18smallserial serial2 autoincrementing two-byte integerData Types table_am_handlerData TypesPG18table_am_handler A table access method handler is declared to return table_am_handler.Pseudo-Types textData TypesPG18text variable-length character stringData Types time with time zoneData TypesPG18time [ (p) ] with time zone timetz time of day, including time zoneData Types time without time zoneData TypesPG18time [ (p) ] [ without time zone ] time of day (no time zone)Data Types timestamp with time zoneData TypesPG18timestamp [ (p) ] with time zone timestamptz date and time, including time zoneData Types timestamp without time zoneData TypesPG18timestamp [ (p) ] [ without time zone ] date and time (no time zone)Data Types triggerData TypesPG18trigger A trigger function is declared to return trigger.Pseudo-Types tsm_handlerData TypesPG18tsm_handler A tablesample method handler is declared to return tsm_handler.Pseudo-Types tsmultirangeData TypesPG18tsrange — Range of timestamp without time zone, tsmultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types tsqueryData TypesPG18tsquery text search queryData Types tsrangeData TypesPG18tsrange — Range of timestamp without time zone, tsmultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types tstzmultirangeData TypesPG18tstzrange — Range of timestamp with time zone, tstzmultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types tstzrangeData TypesPG18tstzrange — Range of timestamp with time zone, tstzmultirange — corresponding MultirangeRange Types › Built-in Range and Multirange Types tsvectorData TypesPG18tsvector text search documentData Types txid_snapshotData TypesPG18txid_snapshot user-level transaction ID snapshot (deprecated; see pg_snapshot)Data Types unknownData TypesPG18unknown Identifies a not-yet-resolved type, e.g., of an undecorated string literal.Pseudo-Types uuidData TypesPG18uuid universally unique identifierData Types voidData TypesPG18void Indicates that a function returns no value.Pseudo-Types xmlData TypesPG18xml XML dataData Types