Docker compose postgres + postgres admin

docker-compose.yaml

version: '3.1'

services:

  db:
    image: postgres
    restart: always
    volumes:
      # uncomment to maintan persistance
        #- ./postgresql/:/var/lib/postgresql/data/
      - ./sql_scripts:/docker-entrypoint-initdb.d/
    environment:
      POSTGRES_PASSWORD: password_example
      POSTGRES_USER: user_example
      POSTGRES_DB: matchers


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

init.sql

CREATE TABLE "sound_recordings" (
  "artist" text NOT NULL,
  "title" text NOT NULL,
  "isrc" text NULL,
  "duration" smallint NULL
);