Hi, I am planning to use some spatial quaries of postgis by importing my JSON format data into a database. It seems that postgres queries-related nodes are still under construction. So, I only want to use Knime to enter my JSON file into PostgreSQL database tables, so later I can use Pgadmin for spatial queries. I am not sure how I should set the DB Insert node to not face errors in the below: [20220912_170808] I have attached a file and workflow as well. image_id_list.json (905.3 KB) HSON to PG.knwf (18.9 KB) Thanks

Json file to PostgreSQL

ipazin September 13, 2022, 8:05am 2

have you seen this topic?

Br,
Ivan

2 Likes