On Jul 23, 6:11 am, [EMAIL PROTECTED] ("Raymond O'Donnell") wrote:
> On 23/07/2007 11:04, Andy Dale wrote:
>
> > The posgres command in the loop should look like so (not sure about the
> > password):
>
> As I understand it, you supply the password via a pgpass file - you
> can't include it on the command line.
>
> Ray.
>
> ---------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> [EMAIL PROTECTED]
> ---------------------------------------------------------------FWIW you can supply the password via a PGPASSWORD environment variable, e.g.: prompt$ PGPASSWORD=secret psql -h pghost -U pguser -d thedb -c "SELECT 'x'" ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
