Automatic backup with password

Hi,

I am trying to write some code to do automatic backup
for PgSQL with pg_dump tool. For safty reason, I still
want the password protection.

1. I tried to use script:
echo "password" | pg_dump -U ....
2. I tried to use Java process, OutputStream.

But pg_dump force password prompt. I don't find a way
to give pg_dump with code. Does anyone have an idea?

Thanks!

Zengfa

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com