PostgreSQL Show Databases. If you are coming from MySQL, you may miss the SHOW TABLES statement that displays all tables in a specific database. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same purpose? You can use the mysql command to connect to mysql server and list available databases.
Since you are new to MySQL, it is. At the command line, type the following command. As an example, say you want to report the size of your databases but you don’t know where to look for that information.
Alternatively, input can be from a file. In addition, it provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks. Viewing the Client Version. What if you could deploy a 3-node streaming replication setup in one command? Or orchestrate a master failover with reslaving of nodes in one command?
In this article, let us review top practical postgreSQL DBA command examples. If you are a mySQL administrator, check-out our examples of mysqladmin command article that we discussed a while back. List the database privileges using psql. The variables shown between the open and closed tags, and , should be replaced with a name you choose.
Reading Time: minute Pre-Flight Check. These instructions are intended for showing (listing) all MySQL databases via the command line.