How do you access a remote PostgreSQL database without installing software locally?

PSQL in a docker container

I assume that, as a developer, you already have Docker installed. Docker container allows you to run commands on various docker images. You can start a “bash” shell in a “Postgres” image very easily.

docker run -it postgres bash

Since Postgres images already contain the ‘psql’ command, we can easily connect to any PostgreSQL database accessible from the Internet.

psql -h dcstack2022.clyrctdltjxl.eu-central-1.rds.amazonaws.com -p 5432 -U postgres -W