And... If in case you may not want to type a whole query... you can also type...

\l+ <database_name> 

and you will get some details about the database, including the size of the database.

And... To get sizes of all databases.

you can just type...

\l+ 

You may need to go into the postgresql command prompt to query with these postgresql helper commands.

Check other postgresql helper commands by typing

\? 

at the postgresql command prompt.

You can enter the following psql meta-command to get some details about a specified database, including its size:

\l+ <database_name> 

And to get sizes of all databases (that you can connect to):

\l+ 

And... If in case you may not want to type a whole query... you can also type...

\l+ <database_name> 

and you will get some details about the database, including the size of the database.

And... If in case you may not want to type a whole query... you can also type...

\l+ <database_name> 

and you will get some details about the database, including the size of the database.

And... To get sizes of all databases.

you can just type...

\l+ 

You may need to go into the postgresql command prompt to query with these postgresql helper commands.

Check other postgresql helper commands by typing

\? 

at the postgresql command prompt.