Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 30E2F9FC210 for ; Thu, 21 Jun 2007 12:19:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21361-03-3 for ; Thu, 21 Jun 2007 12:19:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id F32E49FB80C for ; Thu, 21 Jun 2007 12:19:21 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1I1ORN-0005QI-22 for pgsql-admin@postgresql.org; Thu, 21 Jun 2007 08:19:21 -0700 Message-ID: <11235301.post@talk.nabble.com> Date: Thu, 21 Jun 2007 08:19:21 -0700 (PDT) From: cha To: pgsql-admin@postgresql.org Subject: Re: problem importing data with psql In-Reply-To: <11227946.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: chandresh.rana@metrixline.com References: <11227946.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/223 X-Sequence-Number: 25891 Hi All, Am able to resolve the problem by setting PGPASSWORD=password in my environment variables and passing the -q(quiet) command in my ant script. Cheers, Cha cha wrote: > > Hi All, > > Am using the following command to import tables in my database. I got list > of tables which i need to import. > > So have made ant script and batch file to accomplish the purpose. > > Ant script contains all the configurations with following command : > > > > To call this ant file am passing the following command in my batch file as > : > > call ant -f impdb.xml -Dtable.name=abc > call ant -f impdb.xml -Dtable.name=bcd > > But am not able to import the tables with batch file, though am able to > run the same command from the prompt successfully. > > I have to import 400+ tables , so need to automate the job rather than > manually. > > So Can anyone throw light on this issue? Where am wrong? What's need to be > done? > > Awaiting for the reply. > > Cheers, > Cha > -- View this message in context: http://www.nabble.com/problem-importing-data-with-psql-tf3956986.html#a11235301 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.