Size of a postgresql database

The size of a postgresql database can be obtained using the following query:

$ select pg_size_pretty(pg_database_size('database_name'));
 pg_size_pretty 
----------------
 70 GB
(1 row)