Re: Fieldname size ?? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Fieldname size ??
Date
Msg-id 20011208112158.L48625-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Fieldname size ??  ("J. 'FIK' Brand" <Jurgen.Brand@tip.nl>)
List pgsql-general
On Sat, 8 Dec 2001, J. 'FIK' Brand wrote:

> I'm in the process of converting a database from MS to Postgres. In
> the database there is a table that as fieldnames that are longer that
> 32 characters. I can't change the client software.
>
> The problem is that Postgres does't support fieldnames that are long,
> is it possible to compile Postgres with fieldnames that can be 64
> characters ??

I believe if you change NAMEDATALEN (postgres_ext.h) you can change
the maximum length.  I think you may need to initdb with the new settings.



pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: untaring release-7.1.3 -
Next
From: Brook Milligan
Date:
Subject: Re: papers on datatype design