... | @@ -34,8 +34,7 @@ most often we do that from inside the container |
... | @@ -34,8 +34,7 @@ most often we do that from inside the container |
|
|
|
|
|
```bash
|
|
```bash
|
|
docker ps # get a listing of all containers on this machine
|
|
docker ps # get a listing of all containers on this machine
|
|
docker exec -it wyatt_local_db bash # open an interactive terminal to the DB container called wyatt_local_db
|
|
docker exec -it wyatt_local_db psql -U wyatt # to open psql (DB command line interaction) interactively as user wyatt on DB container wyatt_local_db
|
|
psql -U wyatt # to open psql as user wyatt to interact with the DB (the interactive command line interface to the DB)
|
|
|
|
\l # lists all DB's
|
|
\l # lists all DB's
|
|
\c <name of DB> # connects to DB
|
|
\c <name of DB> # connects to DB
|
|
\d # describes all in that DB
|
|
\d # describes all in that DB
|
... | | ... | |