Re: Max column number.

From: Miguel Angel Conte <diafano(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Max column number.
Date: 2011-07-12 18:25:02
Message-ID: CAB+MjFOpuTH2XK-HxB1dQuCYAEa+ZgfzLgEX66LBf9zsb1kebA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
> Hi Ken,
>
> Do you know a good way to get the max row size in a table?
> Or maybe I'll have to get this information from the metadata....
>
> thanks!
>
>
> On Tue, Jul 12, 2011 at 3:11 PM, ktm(at)rice(dot)edu <ktm(at)rice(dot)edu> wrote:
>
>> On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote:
>> > Unfortunately It's an inherited data model and I can't make any change
>> for
>> > now...
>> > Thanks for your answer!
>> >
>> > On Tue, Jul 12, 2011 at 2:52 PM, Reinoud van Leeuwen <
>> > reinoud(dot)v(at)n(dot)leeuwen(dot)net> wrote:
>> >
>> > > On Tue, Jul 12, 2011 at 02:48:26PM -0300, Miguel Angel Conte wrote:
>> > >
>> > > > Something like:
>> > > > "If I'm not going to exceed the size limit, then I can add a new
>> column"
>> > >
>> > > You want to add columns in your application? Are you sure you have the
>> > > right datamodel?
>> > >
>> > > Reinoud
>> > > --
>> Hi Reinoud,
>>
>> I think you will need to write a function to grovel around in the database
>> to determine what the size of the row would be given a definition. Tedious
>> but straight-forward.
>>
>> Regards,
>> Ken
>>
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Viktor Bojović 2011-07-12 20:16:25 Re: Max column number.
Previous Message ktm@rice.edu 2011-07-12 18:11:21 Re: Max column number.