PostgreSQL: size of a table

select pg_size_pretty(pg_relation_size('foo'));