NEED HELP COPY TO DYNAMIC OUTPUT FILE
От | Yogi Rizkiadi |
---|---|
Тема | NEED HELP COPY TO DYNAMIC OUTPUT FILE |
Дата | |
Msg-id | 797097.88507.qm@web76214.mail.sg1.yahoo.com обсуждение исходный текст |
Ответы |
Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE
|
Список | 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 по дате отправления: