Ken Harris <kharris@lhinfo.com> writes:
> If anyone has a better solution for the username/password, I would love to see
> it, but this works.
In 7.3 you can keep the passwords in a ~/.pgpass file. You generally do
NOT want to use PGPASSWORD, as on many platforms it is possible for
other people to look at your environment variables.
regards, tom lane