Skip to Content

import array type data into database

Oct 18, 2016 at 12:21 PM


avatar image
Former Member

I am loading data from CSV file into the database.There is a column which is an integer array type in the data.While importing data into database it shows an incompatible error.

So when I searched how to insert array type data into a column I found that to give the parameter as ARRAY(the elements of array) and pass it in the INSERT statement.Then I inserted a few rows manually and then exported to see in which format does it stores in the CSV file.But the array column was not found in the CSV file.

So I could not find in which format should be the array elements reside in the CSV file to import it into the database. Thanks in advance for your assistance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers