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'
SELECT
-- *
sum( relpages*8/1024 ) as MB
FROM
pg_class
WHERE
-- relname != ''
-- relname = 'document'
relnamespace = '2200'
On 4/16/07, Trula Thomas <trulathomas@xxxxxxxxx> 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.
