From: Rod Taylor <rbt@rbt.ca>
To: A.M. <agentm@cmu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Column limits in table/ views
Date: 07 Jun 2003 09:48:08 -0400
Message-ID: <1054993688.23997.26.camel@jester> (raw)
In-Reply-To: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.edu>
References: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.edu>
On Fri, 2003-06-06 at 18:02, A.M. 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?
The limit is documented as having to do with the size of a block. The
largest a single row can become is 8k with primitive types (text, and
other variable length types will 'overflow' into another area -- see
TOAST).
Selects should be able to return more columns than that. Both views and
tables create a ROW TYPE to represent it, which is where the limitation
is. Thus, I would not expect you to be able to create a view.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
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: rbt@rbt.ca, agentm@cmu.edu
Subject: Re: Column limits in table/ views
In-Reply-To: <1054993688.23997.26.camel@jester>
* 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