Docker PostgreSQL query output

Question

I have problems with querying my PostgreSQL running in Docker. What im doing is connecting to my db

$ docker exec -it my_db_1 psql -U postgres -d project

I have table block, which has id, name and size for example. My query is like:

SELECT * FROM block WHERE id=1

Where can i see my outputs?

Answer 1

You get output to your terminal STDOUT.

You can get it in one step only by

docker exec -it my_db_1 psql -U postgres -d project -c "SELECT * FROM block WHERE id=1"