Re: Determining table size - Mailing list pgsql-general

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_%'