From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | andy(at)asjohnson(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Add NAMEDATALEN to PG_CONFIG? |
Date: | 2017-05-15 23:34:35 |
Message-ID: | 0d4d1d3a-b93f-7d32-0545-c7b02b3d312e@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-05-15 23:36:18 | Re: union all taking years - PG 9.6 |
Previous Message | Adrian Klaver | 2017-05-15 23:31:33 | Re: union all taking years - PG 9.6 |