> 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.
Just do an 'ls -l' in pgsql/data/base/dbname.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026