Re: Name limitation question - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Name limitation question
Date
Msg-id 200306211135.18984.josh@agliodbs.com
Whole thread Raw
In response to Name limitation question  ("Laura Nichols" <LNichols@oacis.com>)
Responses Re: Name limitation question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Laura,

> I have a quick question.  Is there a limit to the length of a table name /
> column name / procedure name?  For example, Sybase has a limit of 32
> characters for stored procedure names, or some such.  Is there such a limit
> in PostgreSQL?

We had a limit of first 31, then 63 characters.   Either in 7.3 or in 7.4
(beta) that was extended to 128 characters, which should be enough for
anybody.  Unfortunately, I'm not sure what versions of Postgres each of these
limits is associated with, but I'm sure that someone else on this list will
speak up.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: connectby(... pos_of_sibling)
Next
From: Tom Lane
Date:
Subject: Re: Name limitation question