How to import multiple CSV files to a postgres table using pgadmin or other method?
1
vote
3
answers
7072
views
I'm looking to import a folder of over 100+ csv files into one table on PostgreSQL using pgadmin. I have the following script but is there a way to change the file path to all csvs?
COPY schema.table FROM ‘C:\Documents\Data’ DELIMITER ‘,’ CSV HEADER;
Asked by Chris Jenner
(151 rep)
May 21, 2020, 11:03 AM
Last activity: Jun 17, 2024, 07:22 PM
Last activity: Jun 17, 2024, 07:22 PM