Thanks,
but I am looking for a way to pass the password to the command rather
than using another config or password file.
I store my config infos in an xml file.
I thought I could set the environment var as suggested on some sites but
it does not seem to be working.
Alex
Alvaro Herrera wrote:
>On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
>
>
>
>>is ther a way to pass a password to the pg_dump command to avoid being
>>prompted for it.
>>I want to execute the dump from a perl or shell script and dont want to
>>open accees for the user in the pg_hba.conf
>>
>>
>
>Use the ~/.pgpass file. It will work for any libpq program, not just
>pg_dump.
>
>
>