Thread: Get DB Size by row

Hello,

I'm looking to do something like:

select month, mb_size(description) from data where year = 2012 group by month

I also am looking for raw size not compressed size.

Thanks

Ben

On Fri, 20 Jul 2012 08:27:37 -0400 Benjamin Adams <freebsdworld@gmail.com> wrote:

> Hello,
>
> I'm looking to do something like:
>
> select month, mb_size(description) from data where year = 2012 group by month
>
> I also am looking for raw size not compressed size.

octet_length() will give you the size in bytes.  It's not the size in
characters, though, unless the field is using an encoding that's always
1 byte per character.  For character length, use (obviously)
character_length().

--
Bill Moran <wmoran@potentialtech.com>