Re: [GENERAL] Column Sizes

[Adam Ruth]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])