NEED HELP COPY TO DYNAMIC OUTPUT FILE - Mailing list pgsql-sql

From Yogi Rizkiadi
Subject NEED HELP COPY TO DYNAMIC OUTPUT FILE
Date
Msg-id 797097.88507.qm@web76214.mail.sg1.yahoo.com
Whole thread Raw
Responses Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hi admin, i'm gie from
indonesia<br/><br />i wanna ask you how to make a dynamic output file from command COPY TO ?<br /><br />i have tried
this:<br /><br />BEGIN<br /> i:=0;<br /> j:=10;<br /> WHILE i < j LOOP<br /> COPY (SELECT * FROM country) TO<span
style="background-color:rgb(255, 255, 255);"> <span style="color: rgb(255, 0, 0);">'/usr/proj/' || i || '.txt'</span>;
//need attention here</span><br /> END LOOP;<br /> RETURN;<br />END<br /><br />but it seems getting wrong, so what the
rightsyntax's ?<br /><br />Sorry for my bad english and thanks in advance<br /><br /></td></tr></table><br /><hr
size="1"/><a
href="http://sg.rd.yahoo.com/id/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/id/">
Dapatkanalamat Email baru Anda! </a><br /> Dapatkan nama yang selalu Anda inginkan sebelum diambil orang lain! 

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: recursively isolate pedigrees, based only on person_id, mother_id and father_id
Next
From: Pavel Stehule
Date:
Subject: Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE