Can Prisma support multiple PostgreSQL schemas? The Postgresql db connector seem to imply you can only have one (postgresql://USER:PASSWORD@HOST:PORT/DATABASE?schema=myschema). Is there a way in the schema.prisma file to define which PostgreSQL schema a model is defined? We have multiple schemas and we are trying to make a single PosgreSQL schema by adding SQL views that reference the other schemas BUT Prisma doesn’t seem to have much support for SQL Views.

@Eric Hosick 👋 Currently there’s no direct way to have multiple schemas but you can look at this workaround and follow this request as well for updates on this 🙂