Expanding on ENV variables

1

Looking to expand on the DATABASE_URL to add db name / schema like so:

When / Where would be the best place to do so, so that the [deploy] command also has this updated value for migrations.

2

I think you can just put an .env file in your app that includes this:

DATABASE_URL_WITH_SCHEMA=${DATABASE_URL}?schema=public

That .env file support and interpolation seems like a first class feature in Prisma, not something we need to do anything special for.

1 Like
3

Will give this a try and report back!