Sample Header Ad - 728x90

import 100 csv files into postgresql

4 votes
5 answers
4300 views
I have a 100 csv files named sequentially 1,2,3....100.csv I copy the csv files with this script: COPY location FROM 'C:\Program Files\PostgreSQL\9.5\data\´1.csv' DELIMITER ','; I would to execute the COPY with a single script that covers all the files (1,2,3 .... 100.csv). I use pgadminIII on MS Windows
Asked by michal (103 rep)
Apr 1, 2017, 04:17 PM
Last activity: Apr 24, 2025, 07:46 AM