Hello all. I'm creating a multi tenant database, using Postgres, but I'm having trouble. Have this:
object User: Table ("schema_name.table_name") {
// fields
}
But I would like to do something like this.
object User: Table ("$ {schema_name_dynamically} .table_name") {
// fields
}
And the schema name would come with the request. Or something like that.
It's possible? Or is there a better approach? I'm currently using a single schema separating each tenant by an "id_tenant", but I would like to separate by schemas.