length(columnname)<=31 ? - Mailing list pgsql-novice

From Andreas Fitzner
Subject length(columnname)<=31 ?
Date
Msg-id 20020113212701.A25110@jazz.informatik.hu-berlin.de
Whole thread Raw
List pgsql-novice
Hi,

I tried to install OpenInteract (www.openinteract.org), but failed
because obviously postgresql seems to truncate the columnames to 31
character. Is there a way to have longer columnnames under postgresql?


opensci=# create table ThisIsAReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyReallyLongTableName
(testint); 
NOTICE:  identifier "thisisareallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallyreallylongtablename" will
betruncated to "thisisareallyreallyreallyreally" 
CREATE
opensci=#


grateful for any hints,
 regards Andreas

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Table with default value
Next
From: Andreas Fitzner
Date:
Subject: length(columnname), solved