Re: Question about COPY to/from

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Question about COPY to/from
Date: 2006-02-27 20:41:57
Message-ID: 21976.1141072917@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Emi Lu <emilu(at)encs(dot)concordia(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Gardner 2006-02-27 21:53:43 Re: Wish: remove ancient constructs from Postgres
Previous Message Marc G. Fournier 2006-02-27 20:32:55 Re: majordomo unmaintained, postmaster emails ignored?