Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

problem importing data with psql



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-tf3956975.html#a11227925
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group