Postgres Pro
Downloads
Home   >   mailing lists

Thread: Identifier max length

Identifier max length

From
"Birahim FALL"
Date:
Hi,
Certainly a stupid question : What is the max length for identifiers.
A test shows me 63 for a table name.
I just imagine it's the same for constraint name, view name etc ... but I'm not sure.
Or where can I get this info, because it's not in the Postgresl docs !
Thanks

Re: Identifier max length

From
Bruce Momjian
Date:
Birahim FALL wrote:
> Hi, Certainly a stupid question : What is the max length for
> identifiers.  A test shows me 63 for a table name.  I just
> imagine it's the same for constraint name, view name etc ...
> but I'm not sure.  Or where can I get this info, because it's
> not in the Postgresl docs !  Thanks

Yep, all 63 limit.  Not sure where it is documented.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Identifier max length

From
Dennis Gearon
Date:
Bruce Momjian wrote:

>Birahim FALL wrote:
>
>
>>Hi, Certainly a stupid question : What is the max length for
>>identifiers.  A test shows me 63 for a table name.  I just
>>imagine it's the same for constraint name, view name etc ...
>>but I'm not sure.  Or where can I get this info, because it's
>>not in the Postgresl docs !  Thanks
>>
>>
>
>Yep, all 63 limit.  Not sure where it is documented.
>
>
>
The lengths can be found in 7.3.2 manauls at: (kinda haphazard)
----------------------------------------------
Tutorial - Section 1.3 pg 3
Reference - Section CREATE OPERATOR pg 2 of section
Reference - Section LISTEN pg 2 of section
Reference - Section NOTIFY pg 2 of section
Admin - Appendix A- Section 3.1 - pg 108
Admin - Appendix A- Section 3.3.5 - pg 111
User - Section 1.1.1 pg 2
User - Section 1.1.1 pg 5
User - Section 5.3 pg 58