Patch applied. Thanks. Can I get some documentation in the README for all the new functionality.
--------------------------------------------------------------------------- Andreas Pflug wrote: > The current implementation of dbsize doesn't handle tables in > tablespaces correctly, and is quite restricted on objects covered (only > tables and databases, but not tablespaces and indexes). > > The attached patch contributes: > > - database_size(name) > - relation_size(text) > These are the well-known functions, tablespace-aware. > > - pg_tablespace_size(oid) > - pg_database_size(oid) > - pg_relation_size(oid) > Tablespace-aware implementations, used by the upper functions. > pg_relation_size will report sizes of indexes as well. > > - pg_size_pretty(bigint) > Formatting of sizes, to display '146MB' instead of '152885668' > > Regards, > Andreas > > > > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])