N
Neon3mo ago
wise-white

Bug: CSV export doesn't stringify JSON columns

Ran into this bug when exporting data from a table that uses JSONB columns. When I export to CSV, it's rendered in the file as "[object Object]" instead of being properly JSON.stringify-ed, so the export is a lot less useful. When I export to JSON, it does properly include the data from the JSONB columns.
2 Replies
quickest-silver
quickest-silver3mo ago
This should now be fixed: https://github.com/neondatabase/neon-drizzle-studio-changelog/blob/main/CHANGELOG.md "Fixed JSONB datatype when exporting to csv"
GitHub
neon-drizzle-studio-changelog/CHANGELOG.md at main · neondatabase/...
Changelog for Neon Console's Drizzle Studio integration - neondatabase/neon-drizzle-studio-changelog
wise-white
wise-whiteOP3mo ago
Awesome, thanks!

Did you find this page helpful?