Quick Links

Ways to deal with large amount of columns;

From:	a <372660931(at)qq(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Ways to deal with large amount of columns;
Date:	2018-08-30 09:13:54
Message-ID:	tencent_74B211A80785C27C5C3C58D8@qq.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

Thanks so much!

Shore

Responses

Re: Ways to deal with large amount of columns; at 2018-08-30 12:31:17 from David G. Johnston
Re: Ways to deal with large amount of columns; at 2018-08-30 13:03:54 from Andreas Kretschmer
Re: Ways to deal with large amount of columns; at 2018-08-30 13:15:07 from Robert Zenz
Re: Ways to deal with large amount of columns; at 2018-08-30 22:24:28 from Tim Cross
Re: Ways to deal with large amount of columns; at 2018-08-31 08:47:25 from Ben Madin
Re: Ways to deal with large amount of columns; at 2018-08-31 09:31:55 from Brent Wood

Browse pgsql-general by date

	From	Date	Subject
Next Message	Gunnlaugur Thor Briem	2018-08-30 09:24:13	Re: pg_upgrade fails saying function unaccent(text) doesn't exist
Previous Message	saurabh shelar	2018-08-30 07:37:29	Re: Issue with psqlrc with command line.