Problem - PostgreSQL Truncating Column Names to 63 Characters

From: Darren Houston <darren(dot)houston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem - PostgreSQL Truncating Column Names to 63 Characters
Date: 2005-05-13 16:07:43
Message-ID: 5d632eb705051309071546a68e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I guess I'm not typing in the right search string for my question
because I can't find any answer on the Internet. So I'm coming to all
of you for help.

I'm performing a cross-tab type query in PostgreSQL where the returned
data in rows become my column names. The problem I'm facing is that
PostgreSQL is truncating the column names down to 63 characters, and
some of my names need to be a little larger than that. Is a 63 column
name length a limit in PostgreSQL, or is there a
setting/function/compile time option I can enact to overcome this
problem?

Thank you for any help,

Darren H.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wolfgang Keller 2005-05-13 16:15:22 Re: Adventures in Quest for GUI RAD
Previous Message Andrei Gaspar 2005-05-13 15:49:24 Re: windows 1252 encoding