Re: Ways to deal with large amount of columns;

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Ways to deal with large amount of columns;
Date: 2018-08-30 13:03:54
Message-ID: 6403ee64-2322-6034-ff40-ba66b0ecc479@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 30.08.2018 um 11:13 schrieb a:
> Therefore, the column number would be 1000+.

just as a additional note: there is a limit, a table can contains not
more than 250-100 columns, dependsing on column types.
https://wiki.postgresql.org/wiki/FAQ

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Zenz 2018-08-30 13:15:07 Re: Ways to deal with large amount of columns;
Previous Message David G. Johnston 2018-08-30 12:31:17 Re: Ways to deal with large amount of columns;