Question on postgresql query-level variables about kysely HOT 2 CLOSED

Ok so you did mean config parameters. You need to use raw SQL for this. Since local parameters only live until the end of the transaction, you need to use those inside a transcation:

db.transaction().execute(async (trx) => {
  await sql`SET LOCAL foo = ${value}`.execute(trx)
  // Rest of the transaction here
})

from kysely.

I don't think you can do that in postgres. There are no variables in postgres outside functions AFAIK. That might work in some client like psql, but that's a client feature, not postgres.

Or are you abusing postgres config variables here? Anyway, that definitely shouldn't be added as a feature to kysely.

from kysely.