Re: [GENERAL] Admin details - disk space used

> 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