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.sanche...@gmail.com> wrote: > Just: select * from pg_authid; > > En 4 de junio de 2019 15:14:49 Michael Shapiro <mshapir...@gmail.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 >> >> >