Postgres Pro
Downloads
Home   >   mailing lists

Re: Ways to deal with large amount of columns; - Mailing list pgsql-general

From David G. Johnston
Subject Re: Ways to deal with large amount of columns;
Date
Msg-id CAKFQuwZWTUDVCTKcTBwCapPZQ9gp20eLDtiPGz=V-x07Y5xWfw@mail.gmail.com
Whole thread Raw
In response to Ways to deal with large amount of columns;  ("a" <372660931@qq.com>)
Responses Re: Ways to deal with large amount of columns;
List pgsql-general
Tree view
On Thursday, August 30, 2018, a <372660931@qq.com> wrote:
Hi all:

I need to make a table contains projected monthly cashflow for multiple agents (10,000 around).

Therefore, the column number would be 1000+. 

I would need to perform simple aggregate function such as count, sum or average on each cashflow projected.

So if there is anyway of doing this? Will there be anything like define a macro in C that I can manipulate multiple columns by simple word that representing them.

Better to design a data model that doesn't have so many columns. Otherwise generating dynamic SQL via the for,at function and loops and such is your best bet.  Can be down in pl/pgsql or in your preferred programming language.  Psql variables can maybe be useful too.

David J.
 

pgsql-general by date:

Previous
From: Gunnlaugur Thor Briem
Date:
Subject: Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Next
From: Andreas Kretschmer
Date:
Subject: Re: Ways to deal with large amount of columns;