Re: PQconnectdbParams and encrypted password
Tom Lane <[email protected]> Fri, 30 Aug 2019 09:50:32 -0400
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
Dmitry Markman <[email protected]> writes: > I need some help with setting PQconnectdbParams key/value for encrypted = password > suppose I created user with the string > create user foobar with encrypted password =E2=80=98md5f3c33545d22dbf811= 737afb8d0e85597=E2=80=99 > ... > {"password", ??????????????},//I=E2=80=99d like to have = here =E2=80=9Cmd5f3c33545d22dbf811737afb8d0e85597=E2=80=9D, but it doesn=E2= =80=99t work Pretty much the entire *point* of an encrypted password is that the md5 hash is not sufficient to log in with. You need the original string. regards, tom lane