select a.*, owner, author from articles a
INNER JOIN (SELECT username FROM users WHERE users.username = a.ownerId) as owner
INNER JOIN (SELECT username FROM users WHERE users.username = a.authorId) as author

select a.*, owner, author from articles a
INNER JOIN (SELECT username FROM users WHERE users.username = a.ownerId) as owner
INNER JOIN (SELECT username FROM users WHERE users.username = a.authorId) as author

select * from articles
INNER JOIN users ON articles.ownerId = users.id OR articles.authorId = users.id

select * from articles
INNER JOIN users ON articles.ownerId = users.id OR articles.authorId = users.id

  db:
    image: postgres:11.2-alpine
    container_name: postgres-${BRANCH_NAME}
    restart: always
    environment:
      - POSTGRES_USER=${DB_USER}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_DB=${DB_DATABASE}
    volumes:
      - ./project-root/init-postgres.sh:/docker-entrypoint-initdb.d/init-postgres.sh
      - /opt/project-root-db-${BRANCH_NAME}:/var/lib/postgresql/data
    ports:
      - "${DB_PORT}:5432"

  db:
    image: postgres:11.2-alpine
    container_name: postgres-${BRANCH_NAME}
    restart: always
    environment:
      - POSTGRES_USER=${DB_USER}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_DB=${DB_DATABASE}
    volumes:
      - ./project-root/init-postgres.sh:/docker-entrypoint-initdb.d/init-postgres.sh
      - /opt/project-root-db-${BRANCH_NAME}:/var/lib/postgresql/data
    ports:
      - "${DB_PORT}:5432"

#!/bin/bash

psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<EOF
ALTER USER $POSTGRES_USER CREATEDB;
GRANT ALL PRIVILEGES ON DATABASE $POSTGRES_DB TO $POSTGRES_USER;
CREATE DATABASE $DB_DATABASE
EOF

#!/bin/bash

psql --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<EOF
ALTER USER $POSTGRES_USER CREATEDB;
GRANT ALL PRIVILEGES ON DATABASE $POSTGRES_DB TO $POSTGRES_USER;
CREATE DATABASE $DB_DATABASE
EOF