Admin details - disk space used - Mailing list pgsql-general

From Simon Drabble
Subject Admin details - disk space used
Date
Msg-id Pine.LNX.3.96.991027232458.9311G-100000@dragon
Whole thread Raw
Responses Re: [GENERAL] Admin details - disk space used
List pgsql-general
Is it possible somehow to get the space taken up by a database on disk? I know
I can get this as the postgres superuser but it's not particularly clear what
with system tables and stuff, and of course you have to be the postgres user
to do it.

It would be nice to be able to do something like

select diskspace();

and have it return the space taken up by each user table.


If this is a FAQ or in the docs somewhere feel free to flame away - I did look
but not terribly closely as the Braves are losing and I have to keep running
next door.

If it's not possible right now, is it planned? I might take a look at it
myself if it's not planned and other people are interested.


Simon.

--
 "Linux - open doors, not windows."

   Simon Drabble                      It's like karma for your brain.
   simon@eskimo.com


pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] foreign key
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Admin details - disk space used