1. Vik Rubenfeld
  2. Valentina Studio
  3. 木, 4月 25 2019, 01:44 AM
  4.  メールで購読
I would like to import data to a jsonb field from a csv. I've tried things like:


"stripes":true, "solids":true
"stripes:true", "solids:true"
{"stripes":true, "solids":true}


...etc., but I get an error when trying to import to a jsonb field.

What is the correct format for jsonb data to have in a csv file in order for it to import into Valentina postgres?
コメント
There are no comments made yet.
Vik Rubenfeld 承諾済みの回答
Thanks for this great info!
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Vik,

It's better to quote the JSON value, internal quotes should be duplicated.

With default settings it will be

"{""stripes"":true, ""solids"":true}"


Also, you can use another symbol for text qualifier, not used in values - then no need to duplicate the quote.
コメント
There are no comments made yet.
Vik Rubenfeld 承諾済みの回答
UPDATE -- it seems like the 3rd bullet point above does work. :)
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories