How to List All Database in PostgreSQL via Command Line

This article is describing on how to list all database in PostgreSQL Database Server via command line. So, the environment used in order to execute the command to list all database in PostgreSQL Database Server is an environment equipped with a CLI (Command Line Interface). An example of a CLI tool in this context is a terminal or any other interface equipped with a bash prompt.

Steps for listing all database in PostgreSQL via command line will be described in the following steps :

1. Check the PostgreSQL Database Server’s service. It is a necessity for connecting or accessing service of PostgreSQL Database Server. For further reference, read the article titled ‘Check PostgreSQL Service Status’ in this link.

Continue reading “How to List All Database in PostgreSQL via Command Line”

How to Show Available User with Role in PostgreSQL

This article is also an article related on several function exist in PostgreSQL Database Server. The function which is becoming the focus of the writing in this article is about how to show available user with role in PostgreSQL Database Server. In order to achieve it on how to show available user with role in PostgreSQL Database Server, there are several steps which is needed to be performed or executed as shown below :

1. Check whether PostgreSQL Database Server has already been installed. PostgreSQL Database Server must be installed at the first place.

2.It is important to check the already installed PostgreSQL Database Server is currently running or the service representing¬† PostgreSQL Database Server is active and it is prepared to receive incoming connections. The available article which is properly explained on how to check the status of the running service of PostgreSQL Database Server can be shown in the article titled ‘How to Check PostgreSQL Database Server’s service status’ in this link.

  1. If the service of PostgreSQL Database Server is currently running. Try to connect, access and logged in to the PostgreSQL Command Console as shown below :

Continue reading “How to Show Available User with Role in PostgreSQL”

How to Show Available User in PostgreSQL

In this article, the content of the article itself is still related with a certain query which is actually a query performed with the output of how to show available user in PostgreSQL Database Server. This is part of SQL Query where is specifically intended and it can only be useful for PostgreSQL Database Server if there is really a difference on how to show the available user with another type or RDBMS (Relational Database Management System) such as MySQL, Oracle, Microsoft SQL Server,etc. So, in order to achieve on how to show available user in PostgreSQL Database Server, there are several steps needed for the output in the form of available user in PostgreSQL Database Server can be presented. Below are those steps :

Continue reading “How to Show Available User in PostgreSQL”

How to Show Current Database in PostgreSQL

This article is also written for describing about how to show current database accessed or being operated in PostgreSQL Database Server and it is related with the management function of PostgreSQL Database Server.

In order to show the current database accessed or being operated, it must be done by executing a specific command which is typed in the PostgreSQL Command Console.

To be able to log in to the PostgreSQL Command Console, there are several things which is needed to be confirmed.

1. Make sure that the PostgreSQL Database Server is properly installed.

2. Make sure that the service of PostreSQL Databse Server is running and active. Read the article titled ‘Check PostgreSQL Service Status’ in this link.

3. Make sure that PostgreSQL Command Console can be accessed and to be logged in for further operation which in the context of this article is for showing the current database accessed in PostgreSQL Command Console. In order to do that, the article titled ‘Check PostgreSQL Service Status’ in this link can be used as further reference. Below is the process of logging in to PostgreSQL Database Server :

Continue reading “How to Show Current Database in PostgreSQL”

How to Show Current User in PostgreSQL

This is one of the article relates on the management of PostgreSQL Database Server. The function which is the focus of the database management specifically in PostgreSQL Database Server is about how to show current user in PostgreSQL Database Server. The function for showing current user in PostgreSQL Database Server only works after logging in into PostgreSQL Command Console.

The main function in the management of PostgreSQL Database Server to show current user in the PostgreSQL Command Console after logging in is just to make sure that the SQL command executed further later on will be executed by the correct user.

Before logging in to the PostgreSQL Command Console, make sure that PostgreSQL Database Server is installed and the service is currently running. In order to check the service, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After checking the service and the service itself is currently running, just logged in to the PostgreSQL Database Server. In order to logged in to PostgreSQL Command Console, just read the article titled ‘PostgreSQL Database Access from Command Line in Linux’ in this link.

After logging in to PostgreSQL Comamnd Console, the SQL command executed in PostgreSQL Command Console itself where in this context is to show current user in PostgreSQL Database Server is shown below :

Continue reading “How to Show Current User in PostgreSQL”

How to Check PostgreSQL Version via Command Console

This is yet another article relates on PostgreSQL which is focusing to show how to check the PostgreSQL version via command console. Off course, the main point is the PostgreSQL Database Server must be installed and has already started. To check whether the service has already been installed or not just do the following step :

Check the service of PostgreSQL Database Server. To grasp on how to do it, just read the article titled ‘Check PostgreSQL Service Status’ in this link.

After everything has already been checked, mainly the PostgreSQL Database Server installation, the service itself also has already running properly, the process for checking the version can be performed.

PostgreSQL Database Server’s version :

Continue reading “How to Check PostgreSQL Version via Command Console”