Kysely•16mo ago

how to search inside a json type column, I'm using postgresql

I looked in the documentation, and it talks about using the jsonObjectFrom function that is in the kysely lib, but I didn't find it, should I have done the function?

2 Replies

Unknown User•16mo ago

Message Not Public

koskimas•16mo ago

In the meantime you can use raw SQL or write your own helpers around that

db.selectFrom('person')
  .selectAll()
  .where(sql`address->postalCode`, '=', '61710')

db.selectFrom('person')
  .selectAll()
  .where(sql`address->postalCode`, '=', '61710')

Gaming

Programming

how to search inside a json type column, I'm using postgresql