[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
>>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(''));
--Farhan
- Original Message
From: "[EMA
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
