[SQL] NEED HELP COPY TO DYNAMIC OUTPUT FILE

[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 country) TO '/usr/proj/' || i || '.txt'; // need 
attention here
    END LOOP;
    RETURN;
END

but it seems getting wrong, so what the right syntax's ?

Sorry for my bad english and thanks in advance




      Coba Yahoo! Messenger 9.0 baru. Lengkap dengan segala yang Anda sukai 
tentang Messenger! http://id.messenger.yahoo.com