Geometric data types represent two-dimensional spatial objects. Table 8-20 shows the geometric types available in PostgreSQL.

JSON data types are for storing JSON (JavaScript Object Notation) data, as specified in RFC 7159.

Range types are data types representing a range of values of some element type (called the range's subtype). For instance, ranges of

The data type uuid stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards. (Some systems

Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables. OIDs are not added to user-created tables

Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number

The bytea data type allows storage of binary strings; see Table 8-6. Table 8-6. Binary

PostgreSQL supports the full set of SQL date and time types, shown in Table 8-9. The operations available

PostgreSQL provides two data types that are designed to support full text search, which is the activity of searching through a collection of

Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n)