Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Kretschmer
Subject Re: Ways to deal with large amount of columns;
Date
Msg-id 6403ee64-2322-6034-ff40-ba66b0ecc479@a-kretschmer.de
Whole thread Raw
In response to Ways to deal with large amount of columns;  ("a" <372660931@qq.com>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Ways to deal with large amount of columns;
Next
From: Robert Zenz
Date:
Subject: Re: Ways to deal with large amount of columns;