Re: Confronting the maximum column limitation

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Jeff Gentry" <jgentry(at)jimmy(dot)harvard(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Confronting the maximum column limitation
Date: 2008-08-12 21:05:37
Message-ID: dcc563d10808121405x55acf258ma8e4bce689ef2873@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 12, 2008 at 2:15 PM, Jeff Gentry <jgentry(at)jimmy(dot)harvard(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Gentry 2008-08-12 21:11:32 Re: Confronting the maximum column limitation
Previous Message Steve Atkins 2008-08-12 21:04:38 Re: Confronting the maximum column limitation