Postgres Pro
Downloads
Home   >   mailing lists

Thread: Max length name of a database/schema

Max length name of a database/schema

From
Fred BROUARD - SQLpro
Date:
Did you know what is the maximum character length for a name of :
    a database or schema ?
    a table or a view ?
    a column ?
    a constraint ?
    an index ?
thanks
--
Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
Le site du SQL, pour débutants et pros :  http://sqlpro.developpez.com
************************ www.datasapiens.com *************************

Re: Max length name of a database/schema

From
Martijn van Oosterhout
Date:
All the same, there is only one "identifier" type.

It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.

On Fri, Oct 29, 2004 at 01:49:23PM +0200, Fred BROUARD - SQLpro wrote:
> Did you know what is the maximum character length for a name of :
>    a database or schema ?
>    a table or a view ?
>    a column ?
>    a constraint ?
>    an index ?
> thanks
> --
> Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
> Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
> Le site du SQL, pour débutants et pros :  http://sqlpro.developpez.com
> ************************ www.datasapiens.com *************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
Attachment

Re: Max length name of a database/schema

From
Ian Barwick
Date:
On Mon, 1 Nov 2004 10:20:14 +0100, Martijn van Oosterhout
<kleptog@svana.org> wrote:
> All the same, there is only one "identifier" type.
>
> It got bigger recently, but it's either 31 or 63 characters... Look
> through the documentation.

It's been 63 characters since 7.2 or 7.3. See
src/include/postgres_ext.h and look for NAMEDATALEN.

Ian Barwick
barwick@gmail.com