How are passwords encoded in column
passwd of pg_shadow?
select passwd from pg_shadow;
I see values like the following:
... which, doesn't seem to be what I know my password's MD5 hash to be (stripping the leading "md5" obviously). Are the hashes also salted?