| From: | Dennis Gearon <gearond(at)fireserve(dot)net> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Birahim FALL <birahim(dot)fall(at)hispeed(dot)ch>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Identifier max length |
| Date: | 2003-10-22 19:05:33 |
| Message-ID: | 3F96D4FD.1060102@fireserve.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-10-22 19:07:00 | Re: Trigger |
| Previous Message | Andrew Sullivan | 2003-10-22 19:04:49 | Re: [Erserver-general] alternate eRServer build |