Re: column name length - Mailing list pgsql-admin

From Joe Conway
Subject Re: column name length
Date
Msg-id 3C895849.8010609@joeconway.com
Whole thread Raw
In response to column name length  (Felipe Nascimento <Felipe.Nascimento@multivalor.com.br>)
List 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


pgsql-admin by date:

Previous
From: Felipe Nascimento
Date:
Subject: column name length
Next
From: Bhuvan A
Date:
Subject: pg_dump issue across different versions (7.1.2 & 7.2).