Re: problem importing data with psql - Mailing list pgadmin-support

From cha
Subject Re: problem importing data with psql
Date
Msg-id 11235304.post@talk.nabble.com
Whole thread Raw
In response to problem importing data with psql  (cha <chandresh.rana@metrixline.com>)
List pgadmin-support

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
> 

-- 
View this message in context: http://www.nabble.com/problem-importing-data-with-psql-tf3956975.html#a11235304
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Problem editing tables (geom columns)
Next
From: Dave Page
Date:
Subject: New win32 snapshot available