Re: column name length

From: Joe Conway <mail(at)joeconway(dot)com>
To: Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: column name length
Date: 2002-03-09 00:33:13
Message-ID: 3C895849.8010609@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Felipe Nascimento wrote:
> Is there a max length (number of characters) to column names??
>
> I received the following:
> identifier "petb_convidado_partida_participante" will be truncated to
> "petb_convidado_partida_particip"
>
> Tks
> Felipe
>

Yes -- it is 31 characters max by default. You can change it, but only
by modifying the source code and recompiling.

HTH,

Joe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bhuvan A 2002-03-09 06:40:34 pg_dump issue across different versions (7.1.2 & 7.2).
Previous Message Felipe Nascimento 2002-03-09 00:21:18 column name length