Check Postgres db table in Docker
Check Postgres db table in Docker
List running containers to find the container ID or name
docker ps
Access the PostgreSQL container
docker exec -it postgres_container bash
Connect to PostgreSQL
psql -U postgres -d mydatabase
List all tables
\dt
Describe the structure of the ‘ratings’ table
\d ratings
Query data from the ‘ratings’ table
SELECT * FROM ratings;
Leave a comment