Re: problem importing data with psql

From: cha <chandresh(dot)rana(at)metrixline(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: problem importing data with psql
Date: 2007-06-21 15:20:54
Message-ID: 11235322.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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-tf3956973.html#a11235322
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2007-06-21 15:29:25 Re: postgresql and solaris 10: pitch to sysadmins
Previous Message Richard Huxton 2007-06-21 15:16:56 Re: PostgreSQL question re select for update (locking??)