Problem - PostgreSQL Truncating Column Names to 63 Characters - Mailing list pgsql-general

From Darren Houston
Subject Problem - PostgreSQL Truncating Column Names to 63 Characters
Date
Msg-id 5d632eb705051309071546a68e@mail.gmail.com
Whole thread Raw
Responses Re: Problem - PostgreSQL Truncating Column Names to 63 Characters
Re: Problem - PostgreSQL Truncating Column Names to 63 Characters
List 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.

pgsql-general by date:

Previous
From: Andrei Gaspar
Date:
Subject: Re: windows 1252 encoding
Next
From: "Wolfgang Keller"
Date:
Subject: Re: Adventures in Quest for GUI RAD