block23.shell

$ docker exec -it postgres psql -U <username> -d streamlit_db
psql (12.2 (Debian 12.2-2.pgdg100+1))
Type "help" for help.

streamlit_db=# select RM, LSTAT, PRICE
streamlit_db-# from boston
streamlit_db-# where RM > 7
streamlit_db-# limit 2;
  rm   | lstat | price
-------+-------+-------
 7.185 |  4.03 |  34.7
 7.147 |  5.33 |  36.2
(2 rows)

streamlit_db=#\q
$