On 05/15/2017 04:27 PM, Andy Johnson wrote:
Is there a way to find NAMEDATALEN in a database, other than looking at
the source? If not could it be added to the PG_CONFIG eventually?
Andy Johnson
https://www.postgresql.org/docs/9.6/static/runtime-config-preset.html
"max_identifier_length (integer)
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.
"
So:
production=# show max_identifier_length ;
max_identifier_length
-----------------------
63
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
