Wiki / Configuration Parameters
max_identifier_length
Reports the maximum identifier length. It is determined as one less than the value of NAMEDATALEN when building the server. The default value of NAMEDATALEN is 64; therefore the default max_identifier_length is 63 bytes, which can be less than 63 characters when using multibyte encodings.
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
- 63
- category
- Preset Options
- context
- internal
- documented
- true
- enumvals
- Unknown
- extra desc
- Unknown
- lang
- en
- max val
- 63
- metadata version
- 18
- min val
- 63
- name
- max_identifier_length
- short desc
- Shows the maximum identifier length.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- integer
Definition PG 18
Reports the maximum identifier length. It is determined as one less than the value of NAMEDATALEN when building the server. The default value of NAMEDATALEN is 64; therefore the default max_identifier_length is 63 bytes, which can be less than 63 characters when using multibyte encodings.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:c02c395daf724d4231cffe6fe84795c282a825e57e6d8839eb570b5880c88490
Text language: en · wiki-repair-20261023:c02c395daf724d4231cffe6fe84795c282a825e57e6d8839eb570b5880c88490