Finding the size of a Postgres database on disk

Here's how to tell how much space (on disk) a Postgres database takes:

SELECT pg_database.datname,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
  FROM pg_database;

Thanks to Matt Clarkson for the tip.