Emi Lu <emilu@xxxxxxxxxxxxxxxxx> 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
