This is in continuation of My last blog about Meta Commands in PostgreSQL. In last blog I have explained what a Meta command is all about. In next few blogs we will explore few of Meta commands. Lets start exploring databases.
The command we will explore here is:
Once you connected to a database using psql, you will land up on a terminal
You can use
\l to list all the databases available in your cluster.
With this list we can easily figure out that there are 3 databases which is created by me i.e. monitor, pgb_test, and test. Rest of the databases are shipped by default by PostgreSQL. We can see here that \l not only list out the databases of our cluster but it also list a few details about them like character set encoding and collates, their owners & access privileges.
We can use
\c to connect to any database. We will connect to monitor database here using \c command.