[SQL] NEED HELP COPY TO DYNAMIC OUTPUT FILE

Hi admin, i'm gie from indonesia i wanna ask you how to make a dynamic output file from command COPY TO ? i have tried this : BEGIN i:=0; j:=10; WHILE i < j LOOP COPY (SELECT * FROM country) TO '/usr/proj/' || i || '.txt'; // need attention here END LOOP; RETURN; END

Re: [SQL] NEED HELP COPY TO DYNAMIC OUTPUT FILE

Hello COPY in plpgsql are not allowed. regards Pavel Stehule 2009/8/30 Yogi Rizkiadi : > Hi admin, i'm gie from indonesia > > i wanna ask you how to make a dynamic output file from command COPY TO ? > > i have tried this : > > BEGIN > i:=0; > j:=10; > WHILE i < j LOOP > COPY (SELECT * FROM count