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