Win32 Postgresql Command Line Password Specification

From: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Win32 Postgresql Command Line Password Specification
Date: 2005-02-08 08:11:20
Message-ID: 007501c50db5$c6e204f0$0b00a8c0@forge
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have to run some command line commands that I have to run on a windows machine. Like pgsql, dropdb, createdb etc.
All these commands are runned from a php scripts.

Now, my question is how can I specify a User and Password to postgresql database system. I found out how can I say the user, but the password is always asked in the command line. I need this also to be specified in the command.

for example: dropdb database1 -U postgres -W.... always ask a password in the command line.
I want to specify in the command line the pass.

The only solution that I found for this problem is to put the postgre user autentication to trust and to skip the password.

Andy.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Iain 2005-02-08 08:37:54 Re: Win32 Postgresql Command Line Password Specification
Previous Message Joshua D. Drake 2005-02-08 04:21:39 Re: PHP/PDO Database Abstraction Layer