Specifying postgres schema while using a postgres database url
We use prisma migrations with an application that uses kysely, and some direct postgres queries.
The application stores its data in a named postgres schema.
Our application initializes our postgres pool with a database url, stored in an env var.
However, it seems that in order to use prisma with a postgres schema we must append
Additionally, it doesn't seem like there is a way to template that url in the prisma configuration. So we end up needing to use a separate database url env var for prisma, or wrap all prisma invocations in a script that derives the prisma version of the url with the
I'm thinking there must be a better way to do this; what am I missing here?
The application stores its data in a named postgres schema.
Our application initializes our postgres pool with a database url, stored in an env var.
However, it seems that in order to use prisma with a postgres schema we must append
?schema={name}Additionally, it doesn't seem like there is a way to template that url in the prisma configuration. So we end up needing to use a separate database url env var for prisma, or wrap all prisma invocations in a script that derives the prisma version of the url with the
?schemaI'm thinking there must be a better way to do this; what am I missing here?
