chore: add psql instructions for Coder for Docker (coder#926)

sharkymark · ericpaulsen · web-flow · commit c9e1f7bd68c7 · 2022-03-30T09:19:05.000-05:00
* chore: add psql instructions for Coder for Docker

* chore: edit text &amp; formatting

Co-authored-by: Eric Paulsen &lt;ericpaulsen@coder.com&gt;
diff --git a/setup/coder-for-docker/local.md b/setup/coder-for-docker/local.md
@@ -208,6 +208,20 @@ following flags with the `docker run` command:
 If you're interested in using Docker as a workspace provider, please see our
 [deployment instructions](../../admin/workspace-providers/deployment/docker.md).
 
+## Accessing the local PostgreSQL database
+
+To query the local PostgreSQL database using the `psql` [terminal-based
+front-end](https://www.postgresql.org/docs/13/app-psql.html), follow these
+steps.
+
+1. Run `docker ps` to get the name of the Coder container.
+
+1. Exec into the Coder container and connect to the database.
+
+  ```console
+  docker exec -it <CODER_CONTAINER> psql --username=coder --host=0.0.0.0 --port=5433 --dbname=postgres
+  ```
+
 ## Known issues
 
 Currently, Coder for Docker does not support:
