Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about COPY to/from - Mailing list pgsql-general

From Tom Lane
Subject Re: Question about COPY to/from
Date
Msg-id 21976.1141072917@sss.pgh.pa.us
Whole thread Raw
In response to Re: Question about COPY to/from  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Tree view 
Emi Lu <emilu@encs.concordia.ca> writes:
> However,  running "psql -d db -h ...   from STDID", I believe we are
> forced to type the password through prompt command line. Since our data
> population task is through cronjob, is there a way, we can run "COPY ...
> STDIN" by explicitly specifying password so that no human intervention?

Best way is to put the password in ~/.pgpass file belonging to the
account that runs the cron job.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: majordomo unmaintained, postmaster emails ignored?
Next
From: Michael Fuhr
Date:
Subject: Re: Breaking Path/Polygon Data into Pieces