From: Gaetano Mendola <gmendola@mbigroup.it>
To: A.M. <agentm@cmu.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Column limits in table/ views
Date: Sat, 7 Jun 2003 20:08:56 +0200
Message-ID: <004e01c32d1f$dd2b3ba0$10d4a8c0@mm.eutelsat.org> (raw)
References: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.edu>
"A.M." <agentm@cmu.edu> wrote:
> I have 560 columns of NUMERIC(10,14). To not run up against max column
> restraints, I split the information into two tables. Does the column
> limit on tables imply the same limit for views or selects or could I
> potentially select a row across both tables and make a view that hides
> the split?
Hi,
just for curiosity, can I known why do you need a table or a view
with more then 560 Columns ?
Usually have a big table like yours is sign of a not good design.
Regards
Gaetano Mendola
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gmendola@mbigroup.it, agentm@cmu.edu
Subject: Re: Column limits in table/ views
In-Reply-To: <004e01c32d1f$dd2b3ba0$10d4a8c0@mm.eutelsat.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox