Re: Column Sizes

On Nov 12, 2003, at 11:04 AM, Brett Maton wrote:

> Hi NG,
>
> How do I find out the size of a column ?
>
> I am retrieving large objects from the pg_largeobject table and
> creating a
> files, I would like to know the length of the data column so that I can
> implement buffering instead of writing hundreds of small chunks to
> disk.
>
> Any help would be appreciated.
>
> Thanks in advance,
>
> Brett
>
>

I always check for the size this way:

select sum(length(data)) from pg_largeobject where loid = xxx;

Or if you want to know the size of an individual page:

select pageno, length(data) from pg_largeobject where loid = xxx order
by pageno;

Hope this help,

Adam Ruth