PostgreSQL 8.0 table sizes

First, find your namespace's OID:

SELECT oid,* FROM pg_namespace;

.
To calculate table sizes SELECT the following:

SELECT relname, CAST (relpages AS bigint) * 8196 AS size_in_bytes, reltuples FROM pg_class WHERE relnamespace = your_database_namespace_oid ORDER BY size_in_bytes DESC;