Re: Need Help - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Need Help
Date
Msg-id 151434.43695.qm@web31810.mail.mud.yahoo.com
Whole thread Raw
In response to Need Help  (JM <jerome@gmanmi.tv>)
List pgsql-general
--- JM <jerome@gmanmi.tv> wrote:

> how can i get the disk usage for each table? can i do it via SQL?

This function should do what you want:

pg_relation_size(text) or pg_total_relation_size(text)

I found it on the following link:

http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE

Regards,

Richard Broersma Jr.

pgsql-general by date:

Previous
From: JM
Date:
Subject: Need Help
Next
From: 马庆
Date:
Subject: 答复: [GENERAL] Need Help