pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: cha <chandresh.rana@metrixline.com>
To: pgsql-admin@postgresql.org
Subject: problem importing data with psql
Date: Thu, 21 Jun 2007 00:20:52 -0700 (PDT)
Message-ID: <11227946.post@talk.nabble.com> (raw)


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 :

<arg line="/c psql -h ${db.host} -p ${db.port} ${db.name} -U ${db.user} -a
-v -d  -f  ${data.dir}/${db.name}/${table.name}-data.sql"  />

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#a11227946
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




view thread (2+ messages)  latest in thread

Message-ID: <11227946.post@talk.nabble.com>
Permalink:  ../11227946.post@talk.nabble.com/
Also on:    postgresql.org/message-id/11227946.post@talk.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: chandresh.rana@metrixline.com
  Subject: Re: problem importing data with psql
  In-Reply-To: <11227946.post@talk.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox