Re: login role password

Thanks. That is a helpful workaround.

I am asking for this functionality to be added to PgAdmin4, so that when
you select the SQL for a login role you see what PgAdmin3 shows.

CREATE ROLE xxx_user LOGIN
ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09'
SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;

And that the dialog for a login user supports setting an encrypted password.

I know I can run this in an SQL window:

ALTER ROLE xxx_user ENCRYPTED PASSWORD 'md5f349771b7d83b170e8377bd7d09';

but it would be nice if PgAdmin4 supported this in the GUI

On Tue, Jun 4, 2019 at 8:40 AM Isaías Sánchez <isaias(dot)sanchez(dot)l(at)gmail(dot)com>
wrote:

> Just: select * from pg_authid;
>
> En 4 de junio de 2019 15:14:49 Michael Shapiro <mshapiro51(at)gmail(dot)com>
> escribió:
>
>> PgAdmin3 has the ability to see the encrypted password for a login role.
>> That allow me to copy the login role password from one server to another
>> (without having to know the password).
>>
>> I don't see how to see the encrypted password for a login role in PgAdmin4
>>
>>
>