Re:

pg_size_pretty does not take any arguments. You could write your own
procedure to normalize the output.

regards

Andreas


On 05/29/2013 04:33 PM, Birchall, Austen wrote:
> We have some 'big' and some 'small' tablespaces that we what to monitor using pg_tablespace_size
>
> Now we know that we can use pg_size_pretty to tidy up the output but we really need the output to be in either  GB or
MBconsistently regardless of the actual size of the tablespace. 
>
> Any ways to do this?
>
> Thanks
>
> Austen
>
>