https://kotlinlang.org logo
#exposed
Title
# exposed
r

Rodrigo Silva

07/21/2019, 12:22 PM
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.
t

tapac

07/23/2019, 7:44 PM
I guess you may try to make something like:
Copy code
open class SchemaTable(private val name: String) : Table() {
    override val tableName: String 
        get() = "${schema_name_dynamically()}.$name"
}
2 Views