table vs. view maximum columns

From: "A(dot)M(dot)" <agentm(at)cmu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: table vs. view maximum columns
Date: 2003-06-07 03:08:11
Message-ID: 45C1AFDE-9895-11D7-AAB2-0030657192DA@cmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have 560 columns of NUMERIC(10,14). In order not to run up against
max column constraints, 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?

Browse pgsql-admin by date

  From Date Subject
Next Message utomo restu 2003-06-07 07:37:00 about pg_hba.conf ?
Previous Message Jonathan Gardner 2003-06-06 21:38:00 Re: No acceptable C compiler found