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?

if you docker exec -it my_db_1 bash and then psql -U postgres -d project and SELECT * FROM block WHERE id=1 does it show more? — user2915097
– user2915097, Commented Jan 27, 2017 at 10:19

gile · Accepted Answer · 2017-01-27 10:59:02Z

5

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"

answered Jan 27, 2017 at 10:59

gile

6,0341 gold badge30 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Or -f if you want to execute a sql file