problem importing data with psql

[cha]

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

[cha]

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 :

<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