Re: column limit

On Thu, Jan 25, 2007 at 08:34:08 -0700,
Isaac Ben <ib(dot)zero(at)gmail(dot)com> wrote:
> Hi,
> I'm trying to create a table with 20,000 columns of type int2, but I
> keep getting the error message that the limit is 1600. According to
> this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php
> it can be increased, but only up to about 6400. Can anyone tell me
> how to get 20,000 columns?

Can you explain what you are really trying to do? It is unlikely that using
20000 columns is the best way to solve your problem. If we know what you are
really trying to do we may be able to make some other suggestions.
One thing you might start looking at is using an array or arrays.