Pak Jiddat

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


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