By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,724 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

Identifier max length

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
pg***@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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

P: n/a
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



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.