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