I am writing a function for a python environment which needs to import data from a csv file into an existing table. The scope in which the function can execute does not allow for a db SUPERUSER to run the function and so the COPY function is out of the question.
What other options are efficient?
The files range from 100,000 to 1,000,000 rows.
THIS QUESTION HAS ALSO BEEN POSTED HERE