Connecting to a PostgreSQL Database Server

This article is show you how to connect to a PostgreSQL Database Server via an interactive terminal program called psql and via the pgAdmin application.

Before using psql or pgAdmin, Please download and install PostgreSQL database server first. The PostgreSQL installer has also installed some useful tools for working with the PostgreSQL database server. You can connect to the PostgreSQL database server via the psql interactive program or pgAdmin tool.

Connecting to a PostgreSQL via psql

1. Launch SQL Shell(psql)

2. Enter the database server information

Orderly enter Server name/Server IP address, Database name, Port, Username, and Password. Press Enter to accept the default if you want to connect to a local PostgreSQL server.

3. Test it out

You can try the following SQL statement to test it out: SELECT version();

Connecting to a PostgreSQL database server using pgAdmin

1. Launch the pgAdmin

2. Create a new server

Right-click the Servers and select Create>Server to create a new server.

Enter host name, port, database name, user name and password, then save.

3. Connect to the database

click on the Servers node to expand the server. By default, PostgreSQL has a database named postgres.

Open the query tool by choosing the menu item Tool > Query Tool or click the lightning icon.

Enter the query in the Query Editor, click the Execute button, then you will see the result of the query displaying in the Data Output tab:

Copyright © 2019 Cloud Clusters Inc. all right reserved,powered by GitbookRevised on 05/10/2021

results matching ""

    No results matching ""