Re: [ADMIN] Database size with postgres 7.2

2004-01-09 Thread Oli Sennhauser
Hi Robert Thanks for the good start, it worked without a hitch in 7.2. :) So that query lists the size (in kilobytes?) all of the relations and the index's of the relations as well? As you can see in the result header it gives the size in kb. Caution 1: The script is written a little dirty. I

Re: [ADMIN] Database size with postgres 7.2

2004-01-08 Thread Robert
Oli Sennhauser wrote: Hi Robert I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. This script gives you the used

Re: [ADMIN] Database size with postgres 7.2

2004-01-08 Thread Oli Sennhauser
Hi Robert I'm hoping to find a easy way to find the disk space used by each database on a given postgres v7.2 server - I've been looking through the docs and have seen some references to oid2name, but that doesn't really help my situation. This script gives you the used size per object. Unfortu