↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Configuration Parameters

lc_numeric

Sets the locale to use for formatting numbers, 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_numeric
short desc
Sets the locale for formatting numbers.
source
pg-settings-source-snapshot
unit
Unknown
vartype
string

Definition PG 18

Sets the locale to use for formatting numbers, 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:b1923cc1863bb1d8dec638c5d2fe30ff33f366551e29ca2e68c4c20bb0d71c3b

Text language: en · wiki-repair-20261023:b1923cc1863bb1d8dec638c5d2fe30ff33f366551e29ca2e68c4c20bb0d71c3b