Try this:- -- Query returns size of a database calculated from the no. 8k pages allocated to tables SELECT -- * sum( relpages*8/1024 ) as MB FROM pg_class WHERE -- relname != '' -- relname = 'document' relnamespace = '2200'
On 4/16/07, Trula Thomas <[EMAIL PROTECTED]> wrote:
Hello, would anyone know the cript for disk space use (psql)? Please help. Thank you Trula ------------------------------ Ahhh...imagining that irresistible "new car" smell? Check out new cars at Yahoo! Autos.<http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
