Start using PostgreSQL
List PostgreSQL databases
List databases with psql and recognize the maintenance and template databases in a new cluster.
8 minute lesson
~~~
Inside psql, list the databases with:
\lpostgres is the normal maintenance database. PostgreSQL copies template1 when you create an ordinary database. template0 stays clean for restores and databases that need different locale settings.
Use \l+ when you also need sizes and tablespaces.
Lesson completed