Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 744696332AB
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 29 Aug 2009 19:09:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 99115-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Sat, 29 Aug 2009 22:09:06 +0000 (UTC)
X-Greylist: delayed 00:06:40.14281 by SQLgrey-1.7.6
Received: from web76214.mail.sg1.yahoo.com (web76214.mail.sg1.yahoo.com
	[124.108.115.162])
	by mail.postgresql.org (Postfix) with SMTP id 92E0A632736
	for <pgsql-sql@postgresql.org>; Sat, 29 Aug 2009 19:09:05 -0300 (ADT)
Received: (qmail 91187 invoked by uid 60001); 29 Aug 2009 22:02:21 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.id; s=s1024;
	t=1251583341; bh=vpdLmrvFmVZwL1zArILFvPY0JRRb04MRBpHSmRWchkI=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=iRPMBlhb0aeCCCROFtcTNsP4TUDxMmzWaz0ibwx+pglJKYERwfpie5IIEX8NTPXZnGqTazJePf/qb4lPfGZstFX8IlOr8blc/2PDt5z5tv1Dm57yRi1Vne02uB9ME/5iCbZ3njOMQwRFgNmIBf8kPv22WXrCEkDSuWwjZLSBE2E=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.id;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=fpPb46soac5fMREyHDoA2GpxPlJvEfQN4Mz+JjPlZB339LXNQGnc5uuUoMZWxpjeocTD+L56PVzdVu8UWubnt4PxmB7cKFnedJ0IapE43X2Rfjuztq4GjBaHjKsi0/5FnaGDB+La15HWbqJtXxjhzQeKiMXlzpNPehQq13nfJXA=;
Message-ID: <797097.88507.qm@web76214.mail.sg1.yahoo.com>
X-YMail-OSG: 
 Wuj_KD4VM1kGEqAR7SvuGt.bLus9Lb9c21BnvdXSJqhgncyU0J8nbxE7Hq9MkKm9yPqDkasp8eiyJbiPBxZ57eDCiBpA9ZegUAzN4W45OQSduhe3kRf3c1dccD3JoLZalo84eIhspz3iSQ_lE_xJ3UYdzBAQhRPubeBV3vVWj1JRNMjFLBiy.FcMSL0apJtGL8puPZyYlhFzfiPCQRuTsg0gLlOYXxdTHt7RK.VrGx1urK.SVQGerd2sNZxT1WxQhGotqhD1
Received: from [202.93.37.91] by web76214.mail.sg1.yahoo.com via HTTP;
	Sat, 29 Aug 2009 15:02:21 PDT
X-Mailer: YahooMailClassic/6.1.2 YahooMailWebService/0.7.338.2
Date: Sat, 29 Aug 2009 15:02:21 -0700 (PDT)
From: Yogi Rizkiadi <gie05tech@yahoo.co.id>
Subject: NEED HELP COPY TO DYNAMIC OUTPUT FILE
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-965440482-1251583341=:88507"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=4.18 tagged_above=-10 required=5 tests=BAYES_50=0.001,
	DNS_FROM_RFC_BOGUSMX=1.482, HTML_MESSAGE=0.001,
	RCVD_IN_SORBS_WEB=0.619, SUBJ_ALL_CAPS=2.077
X-Spam-Level: ****
X-Archive-Number: 200908/150
X-Sequence-Number: 33059

--0-965440482-1251583341=:88507
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

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:=3D0;
    j:=3D10;
    WHILE i < j LOOP
        COPY (SELECT * FROM country) TO '/usr/proj/' || i || '.txt'; // nee=
d 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

=0A=0A=0A      Coba Yahoo! Messenger 9.0 baru. Lengkap dengan segala yang A=
nda sukai tentang Messenger! http://id.messenger.yahoo.com
--0-965440482-1251583341=:88507
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Hi admin, i'm gie from indonesia<br><br>i wan=
na ask you how to make a dynamic output file from command COPY TO ?<br><br>=
i have tried this :<br><br>BEGIN<br>    i:=3D0;<br>    j:=3D10;<br>    WHIL=
E i &lt; j LOOP<br>        COPY (SELECT * FROM country) TO<span style=3D"ba=
ckground-color: rgb(255, 255, 255);"> <span style=3D"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 right syntax's ?<br><br>Sorry for my bad english and thanks in advance<=
br><br></td></tr></table><br>=0A      <hr size=3D1> <a href=3D"http://sg.rd=
.yahoo.com/id/mail/domainchoice/mail/signature/*http://mail.promotions.yaho=
o.com/newdomains/id/"> Dapatkan alamat Email baru Anda! </a> <br>=0ADapatka=
n nama yang selalu Anda inginkan sebelum diambil orang lain!
--0-965440482-1251583341=:88507--