Connect to PostgreSQL DB - pgAdmin
In this section we will be introduced to pgAdmin an open source administration tool for PostgreSQL, this tool allows us to see our servers, databases and the data contained within the database.
First, launch the pgAdmin application.
The pgAdmin application version 4 will launch on the web browser as shown in the following picture:
Second, right-click the Servers node and select Create > Server… menu to create a server
Third, enter the server name e.g., PostgreSQL and click the Connection tab:
Fourth, enter the host and password for the postgres user and click the Save button:
Fifth, click on the Servers node to expand the server. By default, PostgreSQL has a database named postgres as shown below:
Sixth, open the query tool by choosing the menu item Tool > Query Tool or click the lightning icon.
Seventh, enter the query in the Query Editor, click the Execute button, you will see the result of the query displaying in the Data Output tab:
Last updated