Re: Identifier max length

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Birahim FALL <birahim(dot)fall(at)hispeed(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identifier max length
Date: 2003-10-22 18:13:31
Message-ID: 200310221813.h9MIDVA06071@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kathy Zhu 2003-10-22 18:57:41 setArray
Previous Message Fernando Nasser 2003-10-22 18:05:31 Re: