postgres database and table size

SELECT pg_size_pretty(pg_database_size('foo_db'));
SELECT pg_size_pretty(pg_total_relation_size('bar_table'));