I usually do the following:
for table tbl: select relpages * 8 from pg_class where relname = 'tbl' (This would give you an answer in KB)for a db: select sum(relpages)* 8 from pg_class where relname not like 'pg_%'