How To List All Databases And Tables Using Psql
How to list all databases? The command “\list” or “\l” is used to list all databases. The shorthand for “\list is \l”. The results show database name, owner, encoding method used, access privileges and no of rows selected, etc. If you are comfortable with SQL statements then you can use the following SQL statement to list all databases. How to list all tables? You cannot see tables of any database until unless you have not established the connection to it....