How to use Copy Command in a loop?

[kallem]

hi,

[COPY worktrainees_hi story FROM E'C:\\bcp\\work trainees_histor y.txt' USING DELIMITERS ',' CSV]

the above command is working fine but i have more than 100 tables and related text files i wanted to run in a loop but
when i use a parameter for table name it is giving error so can any one give me example for this

[rski]

Write a script to do that.

[kallem]

can you give sample script i dont know how to do that

[rski]

In linux

for i in <list of tables>;
do
psql <database and user parameters> -c "COPY ${i} FROM E'C:\\bcp\\${i}.txt' USING DELIMITERS ',' CSV"

Probably under windows you sould be able to do that in similar way, but I'm not a windows expert.