Jasen Betts writes:
> On 2009-11-17, Ashesh Vashi wrote:
>> You can always use the environment variable PGPASSWORD to do that.
>> Though - it is not recommended to use for security reason. :(
> as long as it's not in the default environment it's better than a
> command-line password.
On some pl
On 2009-11-17, Ashesh Vashi wrote:
> --000e0cd211e054ab9404788a05cf
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi Dave,
>
> You can always use the environment variable PGPASSWORD to do that.
> Though - it is not recommended to use for security reason. :(
as long as it's not in the default
On 2009-11-16, Gauthier, Dave wrote:
> --_000_482E80323A35A54498B8B70FF2B87980042237CF64azsmsx504amrc_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> Hi:
>
> Is there a way to require and specify a password at the cmd line for a conn=
> ect? At fi
Hi Dave,
You can always use the environment variable PGPASSWORD to do that.
Though - it is not recommended to use for security reason. :(
Please follow the link for the details.
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The
On 16/11/2009 23:05, Raymond O'Donnell wrote:
> On 16/11/2009 22:51, Gauthier, Dave wrote:
>> --username foo --password fee
[snip]
> There are no options such as thesewhat you do instead is use a
Actually, to correct myself, there *are* these options - but the
--password option just forces
On 16/11/2009 22:51, Gauthier, Dave wrote:
> Hi:
>
> Is there a way to require and specify a password at the cmd line for a
> connect? At first glance...
>
> --username foo --password fee
>
> would seem to be what I want. But it just prompts me for a password (after
> interpreting "fee" as
Gauthier, Dave wrote:
Hi:
Is there a way to require and specify a password at the cmd line for a
connect?
You don't want to do that because any user on the system can see the
command, and thus the password. You want to use a .pgpass file instead:
http://www.postgresql.org/docs/8.4/int
Hi:
Is there a way to require and specify a password at the cmd line for a connect?
At first glance...
--username foo --password fee
would seem to be what I want. But it just prompts me for a password (after
interpreting "fee" as the DB name).
Thanks In Advance
