↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 7.0
Historical version. PostgreSQL 7.0 has reached end of support. See the current manual.

Monetary Type

Obsolete Type: The money is now deprecated. Use numeric or decimal instead. The money type may become a locale-aware layer over the numeric type in a future release.

The money type supports US-style currency with fixed decimal point representation. If Postgres is compiled with USE_LOCALE then the money type should use the monetary conventions defined for locale(7).

Table 3-4. Postgres Monetary Types

Monetary TypeStorageDescriptionRange
money4 bytesFixed-precision-21474836.48 to +21474836.47

numeric will replace the money type, and should be preferred.

Report a documentation issue

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