4 replies

Postgrest inserting json array results in stringified array

I'm trying to insert a an array of objects as a json array but it always ends up being strinfied
if it would be just a json then i can do

sql

sql

${recipeData.notes}::jsonb

` but that doesn't work with arrays (

` but that doesn't work with arrays (

cannot cast type record to jsonb`)

Postgrest inserting json array results in stringified array - Drizzle Team