Table 8-4. Character Types Name Description

The PostgreSQL type system contains a number of special-purpose entries that are collectively called pseudo-types

The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the XLOG. This type is a representation

PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base

A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types.

The xml data type can be used to store XML data. Its advantage over storing XML data in a text field is that it checks the

PostgreSQL provides the standard SQL type boolean; see Table 8-19. The

Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals. Table 8-2 lists the available

PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 8-21. It is better to use these types instead of plain

The money type stores a currency amount with a fixed fractional precision; see Table 8-3. The fractional precision is determined by the database's