Bring up Postgres and Adminer

Here's a docker-compose.yml file to use for this

version: '3.1' 
services:

  db: 
    image: postgres 
    restart: always 
    environment: 
      POSTGRES_PASSWORD: example 

  adminer: 
    image: adminer 
    restart: always 
    ports: 
      - 8080:8080 

Now point a browser at localhost:8080

If we want to populate the database we can modify our docker-compose.yml file as follows:

version: '3.1'
 services:
 db:
     image: postgres
     restart: always
     environment:
       POSTGRES_PASSWORD: example
     volumes:
     - ./createdb.sql:/docker-entrypoint-initdb.d/createdb.sql
 adminer:
     image: adminer
     restart: always
     ports:
       - 9000:8080

Our createdb.sql file could look like this:

CREATE DATABASE bird_encyclopedia;
 \c bird_encyclopedia
 CREATE TABLE birds (
   id SERIAL PRIMARY KEY,
   bird VARCHAR(256),
   description VARCHAR(1024)
 );