multiSchema variable

[boreal musk]

Hi all, im trying to use .env to replace schemas value

datasource db { provider = "postgresql" url = env("DATABASE_URL") schemas = ["base", "transactional"] }

change to
datasource db { provider = "postgresql" url = env("DATABASE_URL") schemas = [env("db")] }

but i got the error Expected a string value, but received functional value env("db").

any idea for this?

[wet crystal]

must be the issue in file structure

[boreal musk]

issue in file structure? any more details on that?
cause i using string for schema is working, thinking anyway to change it to dynamic

[wet crystal]

put the .env file in the root folder

[fading basin]

Hey @boreal musk 👋
What you are trying to do is not supported at the moment.

Please refer to this feature request:
https://github.com/prisma/prisma/issues/15089

[boreal musk]

ok, thanks for clarify

[fading basin]

No worries 🙂

[stoic arrow]

Hello, It looks like this is a preview feature but I cant seem to get it working, any pointers? I have enabled it in my prisma.schema but the client wont let me access seperate schemas, it looks like the prisma db pull just renames if there is a clash

[stoic arrow]

I am trying to do const authUsers = await prisma.auth.user.findMany()

// Query the user table in the public schema
const publicUsers = await prisma.public.user.findMany()

I am trying to do ```js
const authUsers = await prisma.auth.user.findMany()

// Query the user table in the public schema
const publicUsers = await prisma.public.user.findMany()```