Thread: 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
Attachment
> 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.