Emi Lu <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
