1. INTRODUCTION

what is the pgAdmin ?

→ pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

1. EXPLORING THE DATABASE

select count(1) from yellow_taxi_data;

select max(tpep_pickup_datetime), min(tpep_pickup_datetime), max(total_amount)
from yellow_taxi_data;

1. PGADMIND

GUI connecting database

1. INSTALLING PGADMIN USING DOCKER

docker run -it \\
    -e PGADMIN_DEFAULT_EMAIL="[email protected]" \\
    -e PGADMIN_DEFAULT_PASSWORD="root" \\
    -p 8080:80 \\
    dpage/pgadmin4