Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 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

Historical version. PostgreSQL 8.4 has reached end of support. See the current manual.

Chapter 22. Localization

Table of Contents

22.1. Locale Support

22.1.1. Overview
22.1.2. Behavior
22.1.3. Problems

22.2. Character Set Support

22.2.1. Supported Character Sets
22.2.2. Setting the Character Set
22.2.3. Automatic Character Set Conversion Between Server and Client
22.2.4. Further Reading

This chapter describes the available localization features from the point of view of the administrator. PostgreSQL supports localization with two approaches:

Using the locale features of the operating system to provide locale-specific collation order, number formatting, translated messages, and other aspects.
Providing a number of different character sets to support storing text in all kinds of languages, and providing character set translation between client and server.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.