Postgres Pro
Downloads
Home   >   mailing lists

Thread: Maximize columns in a table

Maximize columns in a table

From
"Mohlomi Moloi"
Date:
Hello people,

I am currently in a process of designing the database and defining schemas for some survey to be done.
I was curious if there is a way to increase or maximize my number of columns in a table to +-2000 columns as the limit is up to 1600 per table?

I’ve googled a bit and realized that configuring block size/fragment might allow the increment, however I’m not sure if that's a good idea.
Is there a way of achieving this in an efficient way?

Most appreciatively,
Hlomiza


The material transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any retransmission, dissemination, other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it. If you received this in error, please contact the sender and delete the material from any computer.

Re: Maximize columns in a table

From
"A. Kretschmer"
Date:
In response to Mohlomi Moloi :
> Hello people,
>
> I am currently in a process of designing the database and defining schemas for
> some survey to be done.
> I was curious if there is a way to increase or maximize my number of columns in
> a table to +-2000 columns as the limit is up to 1600 per table?

AFAIK no.

I think, you should normalize your table-design. Do you need really 2000
columns in a table?


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Maximize columns in a table

From
"Mohlomi Moloi"
Date:
I have done basic 1st normal form.
The reason for increasing my number of columns was to reduce my number
of TEMPLATES a data capturer has to work with in TELEForm (TELEForm
being my front-end to capture data). 2nd reason is to reduce the size of
my questionnaire.

Thanks,
Hlomiza


-----Original Message-----
From: Andrej [mailto:andrej.groups@gmail.com]
Sent: 20 July 2009 11:27
To: Mohlomi Moloi
Subject: Re: [NOVICE] Maximize columns in a table

2009/7/20 Mohlomi Moloi <mmoloi@khulisa.com>:

> I was curious if there is a way to increase or maximize my number of
columns
> in a table to +-2000 columns as the limit is up to 1600 per table?
No offense, but 1600+ columns is pretty much always a
design flaw.  What are you trying to achieve with that layout?


Cheers,
Andrej


--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes
concise.

http://www.american.edu/econ/notes/htmlmail.htm