problem importing data with psql

From: cha <chandresh(dot)rana(at)metrixline(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: problem importing data with psql
Date: 2007-06-21 07:20:52
Message-ID: 11227946.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message gunartha.nyoman 2007-06-21 09:35:57 back up maintenance schedule
Previous Message Phillip Smith 2007-06-21 05:15:49 Re: initdb problem