Re: pg_database_size

From: John R Pierce <pierce(at)hogranch(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_database_size
Date: 2010-01-17 07:22:50
Message-ID: 4B52BACA.5090109@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AI Rumman wrote:
> What does pg_database_size resturs?
> Bytes or KB?

those functions all return size in bytes. you can use
pg_size_pretty(pg_database_size('dbname')) to pretty print it as MB or
whatever is most appropriate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Kahgee 2010-01-17 15:26:54 Data Generators
Previous Message AI Rumman 2010-01-17 07:10:28 pg_database_size