From: | cha <chandresh(dot)rana(at)metrixline(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problem importing data with psql |
Date: | 2007-06-21 07:19:33 |
Message-ID: | 11227923.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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-tf3956973.html#a11227923
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | filipe paiva | 2007-06-21 07:27:49 | "Failed to create process: 2!" during installation in windows 2000 |
Previous Message | EBIHARA, Yuichiro | 2007-06-21 05:21:03 | Re: standard LOB support |