How to run postgres commands
This document will take you through how to run postgres queries in the main database for each deployment type.
Prerequisites
- This document assumes that you are the administrator and have access to your Sourcegraph instance
Kubernetes
- Exec into the database to run Postgres queries using
kubectl exec -ti PGSQL-Container-Name -- psql -U sg
Docker Compose
- Exec into the database to run Postgres queries using
docker container exec -it pgsql psql -U sg