max_identifier_length is a preset configuration parameter reporting the maximum length of object identifiers for the database instance.
max_identifier_length was added in PostgreSQL 8.0.
max_identifier_length reports the value of
1, which will be
NAMEDATALEN was changed at compile time.
It is not possible to modify
max_identifier_length (or change the
NAMEDATALEN value by any other means). See the
NAMEDATALEN entry for further details.
postgres=# SHOW max_identifier_length; max_identifier_length ----------------------- 63 (1 row)
It is not possible to modify the value of
postgres=# ALTER SYSTEM SET max_identifier_length = 128; ERROR: parameter "max_identifier_length" cannot be changed