Re: how to add more than 1600 columns in a table?

From: pabloa98 <pabloa98(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: how to add more than 1600 columns in a table?
Date: 2019-04-24 22:14:13
Message-ID: CAEjudX6ngqvZ0SeSKbrjxMfvU1BFVjGY+FC29G1YBZoDf2gK3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arrays could work, but it will make our code less clear. It is good to read
the column name (meaningful) than a number. We could use constants, but
then we should maintain them...

Pablo

On Wed, Apr 24, 2019 at 1:24 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:

> On 2019-Apr-24, pabloa98 wrote:
>
> > How could we add more columns?
>
> Sorry.
>
> > Note: Tables are OK. We truly have 2400 columns now. Each column
> represents
> > a value in a matrix.
>
> Maybe you could use arrays?
>
> --
> Álvaro Herrera https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pabloa98 2019-04-24 22:16:45 Re: how to add more than 1600 columns in a table?
Previous Message pabloa98 2019-04-24 22:11:35 Re: how to add more than 1600 columns in a table?