• Browse categories
• PostgreSQL releases
  • PostgreSQL 14 (dev)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5
  • PostgreSQL 9.4 (EOL)

Version charts

Useful overviews

Useful links

max_identifier_length

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.

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)

postgres=# ALTER SYSTEM SET max_identifier_length = 128;
ERROR:  parameter "max_identifier_length" cannot be changed

References

Categories