Postgres Pro
Downloads
Home   >   mailing lists

Re: how to add more than 1600 columns in a table? - Mailing list pgsql-general

From Ron
Subject Re: how to add more than 1600 columns in a table?
Date
Msg-id 42f8e861-4d12-0ceb-ad14-25d927e0db0d@gmail.com
Whole thread Raw
In response to Re: how to add more than 1600 columns in a table?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On 4/24/19 3:22 PM, Adrian Klaver wrote:
On 4/24/19 1:17 PM, pabloa98 wrote:
Hello

Sadly today we hit the 1600 columns limit of Postgresql 11.

How could we add more columns?

Note: Tables are OK. We truly have 2400 columns now. Each column represents a value in a matrix.

Not sure how hit 1600 column limit = having 2400 columns?

I think he means that the design has 2400 columns, and Pg is failing to implement it.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: how to add more than 1600 columns in a table?
Next
From: Tom Lane
Date:
Subject: Re: how to add more than 1600 columns in a table?