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

Re: problem importing data with psql

From: cha <chandresh(dot)rana(at)metrixline(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem importing data with psql
Date: 2007-06-21 15:19:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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.


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 ${} -p ${db.port} ${} -U ${db.user} -a
> -v -d  -f  ${data.dir}/${}/${}-data.sql"  />
> To call this ant file am passing the following command in my batch file as
> :
> call ant -f impdb.xml
> call ant -f impdb.xml
> 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:
Sent from the PostgreSQL - admin mailing list archive at

In response to

pgsql-admin by date

Next:From: chaDate: 2007-06-21 15:24:26
Subject: Re: pg_dump: Exclude multiple tables in version 7.4
Previous:From: Tom LaneDate: 2007-06-21 14:13:31
Subject: Re: initdb problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group