3 ms·
Looks like you have to modify the source code and rebuild from source to get longer identifiers. “ ... The system uses no more than NAMEDATALEN-1 bytes of an
by xyst 6y ago
Looks like you have to modify the source code and rebuild from source to get longer identifiers.
“
...
The system uses no more than NAMEDATALEN-1 bytes of an identifier; longer names can be written in commands, but they will be truncated. By default, NAMEDATALEN is 64 so the maximum identifier length is 63 bytes. If this limit is problematic, it can be raised by changing the NAMEDATALEN constant in src/include/pg_config_manual.h.
...”
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS https://www.postgresql.org/docs/current/sql-syntax-lexical.h...