External Database postgres, select schema

[EnolMy]

Hi,

I'm installing teable in AWS ECS and I need to use a AWS RDS with postgres. I have set the env variables but in this RDS I don't have a public schema, is a shared RDS with one schema for each application.

I'm trying to set the schema in the installation but always teable goes to public schema.

For example, the db-migration container asks for a database url and there, I can set the schema by:

postgres://user:passwornd@url:port/database?current_schema=schema

But in teable container, I only have those variables ( following the installation guide in the official website)

POSTGRES_HOST=teable-db POSTGRES_PORT=5432 POSTGRES_DB=teable POSTGRES_USER=teable

But no variables to set the schema.

I have tried to set it in those variables, next to the database name, in the host...but always teable looks for public schema

Is there any possibilitie to set other schema than public?

Thanks

[that0n3guy]

Based on the name of the variable, I'm guessing that prisma is what they are using... did you try specifying schema in your PRISMA_DATABASE_URL like so:

https://www.prisma.io/docs/orm/reference/connection-urls