Re: how to know the current size of a database

[Farhan Mughal <farhanhafeezmughal@xxxxxxxxxxx>]

>>I want to know about the size of my database. For example, I want to know
>>how many Mb of data for current myDatabase database in a postgres server.

>>How I can do that?

Try the following query:
select pg_size_pretty(pg_database_size('<DATABASE NAME>'));

--Farhan

----- Original Message ----
From: "son@xxxxxxxxxxxx" <son@xxxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Wednesday, 19 September, 2007 3:36:02 PM
Subject: how to know the current size of a database

Hello

I want to know about the size of my database. For example, I want to know
how many Mb of data for current myDatabase database in a postgres server.

How I can do that?
Thanks



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

---

Yahoo! Answers - Get better answers from someone who knows. Try
it now.