Skip to Content
avatar image
Former Member

import array type data into database

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers