Geometric Types

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

2016-10-12 11:33:23
Range Types

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

2016-10-12 11:34:00
JSON Types

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

2016-10-12 11:33:37
UUID Type

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

2016-10-12 11:34:27
Object Identifier Types

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

2016-10-12 11:33:45
Binary Data Types

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

2016-10-12 11:32:23
Text Search Types

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

2016-10-12 11:34:23
Enumerated Types

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

2016-10-12 11:33:16
Date/Time Types

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

2016-10-12 11:33:04
Bit String Types

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)

2016-10-12 11:32:23