How to Access the Postgres Database Using psql

This guide explains how to connect to the Postgres database running in a Docker container using psql. We are trying to hit the DAPM_ResourceRegistry

Step 1: Open a Terminal

Make sure you have psql installed in your development environment. If it's not installed, follow instructions for your OS to install it.

Step 2: Connect to the Database

Use the following command to connect to the Postgres database running in the Docker container:

psql -h localhost -p 5433 -U postgres -d DAPM_ResourceRegistry

Step 3: Make youre queries`(example)

SELECT * FROM "Pipelines";