Re: Confronting the maximum column limitation - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Confronting the maximum column limitation
Date
Msg-id dcc563d10808121405x55acf258ma8e4bce689ef2873@mail.gmail.com
Whole thread Raw
In response to Confronting the maximum column limitation  (Jeff Gentry <jgentry@jimmy.harvard.edu>)
Responses Re: Confronting the maximum column limitation
List pgsql-general
On Tue, Aug 12, 2008 at 2:15 PM, Jeff Gentry <jgentry@jimmy.harvard.edu> wrote:
> Hi there ...
>
> I recently discovered that there is a hard cap on the # of columns, being
> at 1600.  I also understand that it is generally unfathomable that anyone
> would ever feel limited by that number ... however I've managed to bump
> into it myself and was looking to see if anyone had advice on how to
> manage the situation.

The generic solution without making too much work is to store similar
data types in an arrayed type in the db.

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Confronting the maximum column limitation
Next
From: David Siebert
Date:
Subject: Re: 8.3.1 Vs 8.3.3