Sample Header Ad - 728x90

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