Contents
max_identifier_length
A preset configuration parameter reporting the maximum length of object identifiers
max_identifier_length is a preset configuration parameter reporting the maximum length of object identifiers (in bytes) for the database instance.
max_identifier_length was added in PostgreSQL 8.0.
Usage
max_identifier_length reports the value of NAMEDATALEN - 1, which will be 63 unless 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.
Change history
- PostgreSQL 8.0
- added (commit 66989aa2)
Examples
postgres=# SHOW max_identifier_length; max_identifier_length ----------------------- 63 (1 row)
It is not possible to modify the value of max_identifier_length:
postgres=# ALTER SYSTEM SET max_identifier_length = 128; ERROR: parameter "max_identifier_length" cannot be changed
References
- PostgreSQL documentation: max_identifier_length