How to use copy in a loop in windows?

Sukuchha

New Member

Join Date: Apr 2011

Posts: 1
#1

How to use copy in a loop in windows?

Apr 28 '11, 01:35 PM

How to use copy in a loop in windows?

Last edited by Niheel; Nov 5 '11, 08:36 PM.
Tags: None

rski

Recognized Expert Contributor

Join Date: Dec 2006
Posts: 700

May 2 '11, 08:48 AM

Under windows it should be something like that

Code:

for %i in (<list of tables separated by spaces>)
do 
psql <database and user parameters> -c "COPY %i FROM E'C:\\bcp\\%i.txt' USING DELIMITERS ',' CSV"

How to use copy in a loop in windows?

How to use copy in a loop in windows?

Comment