PostgreSQL: Documentation: 11: Chapter 8. Data Types

Documentation → PostgreSQL 11

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

Chapter 8. Data Types
Prev	Up	Part II. The SQL Language	Home	Next

Chapter 8. Data Types

Table of Contents

8.1. Numeric Types

8.1.1. Integer Types
8.1.2. Arbitrary Precision Numbers
8.1.3. Floating-Point Types
8.1.4. Serial Types

8.2. Monetary Types

8.3. Character Types

8.4. Binary Data Types

8.4.1. bytea Hex Format
8.4.2. bytea Escape Format

8.5. Date/Time Types

8.5.1. Date/Time Input
8.5.2. Date/Time Output
8.5.3. Time Zones
8.5.4. Interval Input
8.5.5. Interval Output

8.6. Boolean Type

8.7. Enumerated Types

8.7.1. Declaration of Enumerated Types
8.7.2. Ordering
8.7.3. Type Safety
8.7.4. Implementation Details

8.8. Geometric Types

8.8.1. Points
8.8.2. Lines
8.8.3. Line Segments
8.8.4. Boxes
8.8.5. Paths
8.8.6. Polygons
8.8.7. Circles

8.9. Network Address Types

8.9.1. inet
8.9.2. cidr
8.9.3. inet vs. cidr
8.9.4. macaddr
8.9.5. macaddr8

8.10. Bit String Types

8.11. Text Search Types

8.11.1. tsvector
8.11.2. tsquery

8.12. UUID Type

8.13. XML Type

8.13.1. Creating XML Values
8.13.2. Encoding Handling
8.13.3. Accessing XML Values

8.14. JSON Types

8.14.1. JSON Input and Output Syntax
8.14.2. Designing JSON documents effectively
8.14.3. jsonb Containment and Existence