>>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@raider.co.nz" <son@raider.co.nz> To: pgsql-general@postgresql.org Sent: Wednesday, 19 September, 2007 3:36:02 PM Subject: [GENERAL] 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?