cotton
cotton copied to clipboard
Support schemas in query builder
I might be missing something, but I don't see any examples of using the query builder to run a query in a specific schema. Looking through the code, I don't see any functions on the query builder to add a schema prefix either. I tried the snippet below to query my database:
const users = await db.table("app.user").where("id", 1).execute();
console.log(users);
But it fails with a PostgresError: relation "app.user" does not exist
Did you solve the above issue?
I wasn't able to solve the issue using the query builder. I had to write out the whole query.