how to add more than 1600 columns in a table?
| От | pabloa98 |
|---|---|
| Тема | how to add more than 1600 columns in a table? |
| Дата | |
| Msg-id | CAEjudX7ZtdVFAENPQUWVMe741N0me0Op24GHE4ibPdm--hJHvw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: how to add more than 1600 columns in a table?
Re: how to add more than 1600 columns in a table? Re: how to add more than 1600 columns in a table? Re: how to add more than 1600 columns in a table? Re: how to add more than 1600 columns in a table? Re: how to add more than 1600 columns in a table? Re: how to add more than 1600 columns in a table? |
| Список | pgsql-general |
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.
We have millions of rows so I would prefer not to transpose each row to (x, y, column_value) triplets because it will make all our code more difficult of what it is.
Any help, very appreciated.
Pablo
В списке pgsql-general по дате отправления: