Re: Defining Role Privileges

On 2012-02-08, Carlos Mennens <carlos.mennens@gmail.com> wrote:

> ALTER ROLE tom ENCRYPTED PASSWORD 'md5081bea17b5503506d29531af33cc6f4e';
>
> \password tom
>
> Is there a downside to using the \password psql command? Is it also
> encrypted like the statement above? How do you create roles and do you
> do it manually or have some kind of template?

I checked that a few weeks ago when doing the latter version the
password is translated into a form similar to former version
your chosen new password is sent over the wire encrypted.

--
⚂⚃ 100% natural