| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | MURAT KOÇ <m(dot)koc21(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Changing Passwords as Encrypted not Clear-Text |
| Date: | 2011-12-19 16:18:02 |
| Message-ID: | CABUevEw5+DoBq1=W6+Q_Sp-xbRNtju8EhZVNwYYVTZ=CquXjzg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Dec 19, 2011 at 15:31, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> On Mon, 2011-12-19 at 15:01 +0200, MURAT KOÇ wrote:
>> Is it possible to see changing passwords as encrypted?
>
> Nope.
>
>> How should I change password or what is the correct sql statement to change user password?
>>
>
> There's only one way to change a password: ALTER USER... PASSWORD...
Not really. You can use "\password" in psql, or you can use
PQencryptPassword() in libpq. I don't know if that function is exposed
in other client drivers, but it's certainly been in libpq for quite a
while.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Kevin McCaffrey | 2011-12-19 16:20:07 | Re: New User: PostgreSQL Setup - "The Program 'postgress' is needed by initdb but was not found in the same directory..." |
| Previous Message | Pavel Stehule | 2011-12-19 16:14:31 | Re: Feature Request: Better handling of foreign keys in DELETE statements |