PostgreSQL supports the common SQL data types; it also supports some unexpected ones, such as JSON. Check some of the most notable data types below:
Numeric Types : “Numeric types consist of two, four, and eight-byte integers; four and eight-byte floating-point numbers; and selectable-precision decimals.”
Character Types : SQL defines two primary character types: “character varying(n) and character(n), where n is a positive integer. Both of these types can store strings up to n characters in length. The notations VARCHAR(n) and CHAR(n) are aliases for character varying(n) and character(n).”
Binary Data Types : A binary string is a sequence of bytes.
Date/Time Types : These store dates, times, or dates and times (timestamps).
Boolean : Boolean values store only TRUE, FALSE, and NULL values.
Enumerated Types : “Enumerated (ENUM) types comprise a static, ordered set of values. They are equivalent to the ENUM types supported in a number of programming languages. An example of an ENUM type might be the days of the week, or a set of status values for a piece of data”.
XML : The XML data type stores XML data.
JSON : The JSON data type stores JSON (JavaScript Object Notation) data.
