© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
10 replies
TARS

insert an array of objects

Hello, I'm trying to insert an array of objects into a supabsae column.

It's an array of these kinds of objects, and it's only strings.
{ id: response.data.public_id, url: response.data.secure_url }

The funny thing is that in supabase I get a lot of \ etc instead of spaces. How Can I deal with this?

This is how it looks in supabase:

[
  "{\"id\":\"hostpictureupload/hjpxjha1tyysgnwi9w9z\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/hjpxjha1tyysgnwi9w9z.jpg\"}",
  "{\"id\":\"hostpictureupload/irrxsmu6ri6u9k0ibcgp\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/irrxsmu6ri6u9k0ibcgp.jpg\"}",
  "{\"id\":\"hostpictureupload/uzk1fmgoygeq3m2qxjlh\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/uzk1fmgoygeq3m2qxjlh.jpg\"}"
]
[
  "{\"id\":\"hostpictureupload/hjpxjha1tyysgnwi9w9z\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/hjpxjha1tyysgnwi9w9z.jpg\"}",
  "{\"id\":\"hostpictureupload/irrxsmu6ri6u9k0ibcgp\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/irrxsmu6ri6u9k0ibcgp.jpg\"}",
  "{\"id\":\"hostpictureupload/uzk1fmgoygeq3m2qxjlh\",\"url\":\"https://res.cloudinary.com/duj052tmt/image/upload/v1661512384/hostpictureupload/uzk1fmgoygeq3m2qxjlh.jpg\"}"
]


Why are there \ ?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

how can I pass an array of objects to an rpc call?
SupabaseSSupabase / help-and-questions
4y ago
Return array of objects grouped by date
SupabaseSSupabase / help-and-questions
4y ago
Add a new property to all objects in an array ?
SupabaseSSupabase / help-and-questions
4y ago
Logflare converting object to array of objects on ingestion.
SupabaseSSupabase / help-and-questions
7mo ago