i am workin on this docker compose file:

services:
  api:
    build:
      context: ./
      dockerfile: ./api/Dockerfile
    container_name: api
    ports:
      - "8911:8911"
    depends_on:
      - postgis
    env_file:
      - .env
    environment:
      - DATABASE_URL=postgresql://postgres:postgrespw@postgis:5432/ffy_dev
    entrypoint: /bin/sh -c "sleep 5 && bash serve-api.sh"

what i would expect it to do is that it first ready all the entries from .env file. and then the environment variable. The issue i am having is, that i need to change one single variable (DATABASE_URL) for this api service. and this entry is also in the .env file. so what i need is to somehow overwrite the one in the .env file with another one.

This way here does not work. is there a way for it?

Thanks a lot!