Wiki / Configuration Parameters
lc_monetary
Sets the locale to use for formatting monetary amounts, for example with the to_char family of functions. Acceptable values are system-dependent; see Section 23.1 for more information. If this variable is set to the empty string (which is the default) then the value is inherited from the execution environment of the server in a system-dependent way.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- C
- category
- Client Connection Defaults / Locale and Formatting
- context
- user
- documented
- true
- enumvals
- Unknown
- extra desc
- An empty string means use the operating system setting.
- lang
- en
- max val
- Unknown
- metadata version
- 18
- min val
- Unknown
- name
- lc_monetary
- short desc
- Sets the locale for formatting monetary amounts.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- string
Definition PG 18
Sets the locale to use for formatting monetary amounts, for example with the to_char family of functions. Acceptable values are system-dependent; see Section 23.1 for more information. If this variable is set to the empty string (which is the default) then the value is inherited from the execution environment of the server in a system-dependent way.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:fa0290490c50e569148bbec986b9a2272ec07e93a8b450e6367ddeeef997c02e
Text language: en · wiki-repair-20261023:fa0290490c50e569148bbec986b9a2272ec07e93a8b450e6367ddeeef997c02e