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
>
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? |