Hello COPY in plpgsql are not allowed.
regards Pavel Stehule 2009/8/30 Yogi Rizkiadi <gie05t...@yahoo.co.id>: > 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 > > > ________________________________ > Dapatkan alamat Email baru Anda! > Dapatkan nama yang selalu Anda inginkan sebelum diambil orang lain! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
