[EMAIL PROTECTED] wrote:
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.
SELECT pg_size_pretty(pg_database_size(current_database()));
-- Dante
---(end of broadcast)-
On Sep 19, 2007, at 5:36 AM, [EMAIL PROTECTED] wrote:
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.
If you don't need an exact size, this query will be a lot faster than
the size functions
- Original Message
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
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
am Wed, dem 19.09.2007, um 22:36:02 +1200 mailte [EMAIL PROTECTED] folgendes:
> 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.
http://www.postgresql.org/docs/8.1/interactive/functions
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
