Re: login role password

2019-06-04 Thread Michael Shapiro 
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 
wrote:

> Just: select * from pg_authid;
>
> En 4 de junio de 2019 15:14:49 Michael Shapiro 
> 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
>>
>>
>

Re: login role password

2019-06-04 Thread Isaías Sánchez 

Just: select * from pg_authid;

En 4 de junio de 2019 15:14:49 Michael Shapiro  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

login role password

2019-06-04 Thread Michael Shapiro 
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