how to configure postgres schema
I am using postgres db for better-auth, my tables were present in a user schema not in public schema
how to make sql queries to get executed in the proper schema, by default all the sql queries are getting executed in public schema of postgres
const db = new Kysely({
dialect: new PostgresJSDialect({
postgres: postgresConn,
}),
});
const auth = betterAuth({
database: {
dialect: new PostgresJSDialect({ postgres: postgresConn }),
type: 'postgres', // ✅ Explicitly specify type
},})
using this setup for better-auth and postgress integration
the queries are getting executed as
"SELECT * from account"
but the queries need to executed as
"SELECT * from schema_name.account"
how to achive this4 Replies
Did you figure this out?
no
For
Postgres pool, you can add the following option:
Perhaps there is something similar for Kysely CREATE ROLE better_auth WITH LOGIN PASSWORD 'password';
ALTER ROLE better_auth SET search_path TO account;
GRANT ALL PRIVILEGES ON SCHEMA account TO better_auth;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA account TO better_auth;
creating a user and assigning it a schema and using this user to make database connection is working