Supported Versions: Current (12) / 11 / 10 / 9.6 / 9.5 / 9.4
Development Versions: devel
Unsupported versions: 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 supported versions listed above instead.

3.2. Monetary Type

Deprecated: The money type is deprecated. Use numeric or decimal instead, in combination with the to_char function. The money type may become a locale-aware layer over the numeric type in a future release.

The money type stores U.S.-style currency with fixed decimal point representation. If Postgres is compiled with locale support then the money type uses locale-specific output formatting.

Input is accepted in a variety of formats, including integer and floating point literals, as well as "typical" currency formatting, such as '$1,000.00'. Output is in the latter form.

Table 3-3. Monetary Types

Type Name Storage Description Range
money 4 bytes Fixed-precision -21474836.48 to +21474836.47