ExecutePostgresCommands.adoc

# Run Postgres
docker run --name dev-postgres -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword -d postgres:11

# CREATE db coursedb
docker exec dev-postgres psql -U postgres -c "CREATE DATABASE coursedb"

# Verify docker container dev-postgres is running, stop, restart
docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
f2d2922b5af6        postgres:11         "docker-entrypoint.s…"   16 minutes ago      Up 16 minutes       0.0.0.0:5432->5432/tcp   dev-postgres
docker stop dev-postgres
dev-postgres
docker ps -a
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                       PORTS               NAMES
f2d2922b5af6        postgres:11         "docker-entrypoint.s…"   16 minutes ago      Exited (137) 4 seconds ago                       dev-postgres
docker start dev-postgres
dev-postgres

# Remove all stop container
docker container prune


# Get into docker container:
docker exec -it dev-postgres bash

\c coursedb


coursedb=# \dt
          List of relations
 Schema |   Name   | Type  |  Owner
--------+----------+-------+----------
 public | employee | table | postgres
(1 row)


coursedb=# \d employee
                     Table "public.employee"
 Column |          Type          | Collation | Nullable | Default
--------+------------------------+-----------+----------+---------
 id     | bigint                 |           | not null |
 name   | character varying(255) |           |          |
 role   | character varying(255) |           |          |
Indexes:
    "employee_pkey" PRIMARY KEY, btree (id)


coursedb=# select * from employee;
 id |     name      |  role
----+---------------+---------
  1 | Bilbo Baggins | burglar
  2 | Frodo Baggins | thief
(2 rows)


coursedb=# insert into employee (id, name, role) values (3, 'Weiping', 'CEO');
INSERT 0 1
coursedb=# \q