Pak Jiddat - Innovative Software Services

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

List all databases for Postgresql

Created On: 25 Nov, 2016: 10:18:41 - Tags : database management

Url: http://dba.stackexchange.com/questions/1285/how-do-i-list-all-databases-and-tables-using-psql

To list all postgresql databases, first we need to login to the postgresql console using the command psql. This command should be run as user postgres. After that run the command \list. This will list all databases. To run queries on the database fist run the command \connect database_name. Then run your query.


Related Articles

  1. Upgrading Postgresql from version 9.4 to 9.6
  2. Upgrading MySQL server from version 5.6 to 8.0
  3. Ignoring errors during MySQL import
  4. MariaDB/MySQL user password not being set
  5. Sorting a MySQL string column as a number
  6. MySQL server out of resources
  7. MySQL Tuner
  8. Create backup of Mongo Db database
  9. Deleting a Mongo Db database
  10. How to login to MySQL server as root user on Plesk
  11. Restoring a database backup in Plesk
  12. Solution for mysql header mismatch error
  13. Backing up and Restoring MongoDB data
  14. Removing Replication in MongoDb
  15. Exporting Mysql database data in CSV format using Mysql Work Bench