Обсуждение: Where are password hashes stored?

This is v9.6, if it matters.

I need to send a screenshot of roles and their password hashes, but I can't 
seem to find the relevant table, and Google only shows pages about .pgpass 
and crypto.

Thanks.

-- 
Angular momentum makes the world go 'round.

Greetings,

* Ron (ronljohnsonjr@gmail.com) wrote:
> This is v9.6, if it matters.
>
> I need to send a screenshot of roles and their password hashes, but I can't
> seem to find the relevant table, and Google only shows pages about .pgpass
> and crypto.

pg_authid

Thanks,

Stephen

> On Mar 22, 2021, at 11:59 AM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> This is v9.6, if it matters.
>
> I need to send a screenshot of roles and their password hashes, but I can't seem to find the relevant table, and
Googleonly shows pages about .pgpass and crypto. 
>
> Thanks.

select * from pg_shadow;

On 3/22/21 1:01 PM, Stephen Frost wrote:
> Greetings,
>
> * Ron (ronljohnsonjr@gmail.com) wrote:
>> This is v9.6, if it matters.
>>
>> I need to send a screenshot of roles and their password hashes, but I can't
>> seem to find the relevant table, and Google only shows pages about .pgpass
>> and crypto.
> pg_authid
>
Thanks.
> Thanks,

>
> Stephen

-- 
Angular momentum makes the world go 'round.