Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Append an object into an array from a jsonb column in Postgres - Theo's Typesafe Cult
TTC
Theo's Typesafe Cult
•
3y ago
midknight
Append an object into an array from a jsonb column in Postgres
Hey guys I
'm looking to insert a jsonb object from a column into an array of this same column in SQL
I tried using jsonb
_set and jsonb
_insert methods but I always end up with an empty array but the object is not null
Does anyone know how to do that
?
Theo's Typesafe Cult
Join
26,564
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
Iterate over an array and create a new sorted object.
TTC
Theo's Typesafe Cult / questions
4y ago
Infer type of object values in array
TTC
Theo's Typesafe Cult / questions
3y ago