Re: Max column number. - Mailing list 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@rice.edu <ktm@rice.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.v@n.leeuwen.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