Linux Administration Cookbook

Listing, creating, and selecting databases and tables

Some people find it easier to remember Postgres commands and syntax compared to MariaDB and MySQL. Personally, I always have to look them up, which results in liberal use of \?, which drops you into the help menu.

Starting at the basics, use \l to list all databases that Postgres manages:

postgres-# \l                                  List of databases   Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- postgres | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 |  template0 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres +           | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_GB.UTF-8 | en_GB.UTF-8 | =c/postgres ...