List Databases in PostgreSQL In PostgreSQL \list or \l command is used for listing databases in server. Login to PostgreSQL database command prompt using command ‘sudo -u postgres psql‘ from terminal. Command :- postgres=# \list Examples :- Login to your PostgreSQL server using command line. You will get PostgreSQL database prompt like postgres=# . Now use execute l or list command to list all databases. Using list Command: postgres=# \list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ———–+———-+———-+———+——-+———————– mydb | postgres |…
Read More