Phillip Stack
Reputation: 3378
Import Data From csv Into Postgresql WITHOUT COPY
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
Upvotes: 0
Views: 647
Answers (1)
Related Questions
- How to import CSV file data into a PostgreSQL table
- copy data from csv to postgresql using python
- Postgres Copy select rows from CSV table
- Using COPY instead of INSERT within python for postgresql
- Import Error on CSV Import with Postgress COPY
- CSV data into postgreSQL using Python
- Importing CSV file into postgreSQL but have duplicates
- importing CSV data into postgreSQL using Python
- Import CSV without primary key to existing table
- Copy content from a csv to PostgreSQL table