Re: Column limits in table/ views - Mailing list pgsql-sql

From Gaetano Mendola
Subject Re: Column limits in table/ views
Date
Msg-id 004e01c32d1f$dd2b3ba0$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to Column limits in table/ views  ("A.M." <agentm@cmu.edu>)
List pgsql-sql
"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






pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Join" on delimeter aggregate query
Next
From: Tom Lane
Date:
Subject: Re: "Join" on delimeter aggregate query