moving from mysql to pgsql

[mws at alpenjodel.de]

Hello Noel!


On 04.10.2017 23:42, Noel Butler wrote:
> As a test, this is testing123 in sha512
> $6$Z6I5oyWUed.tmNUs$0ScF2w3ejPWFAX/3F6DgMyWpbXLq0DD6blL8rwBpSHGWaZ9RiXlpo5PPZFoJPZWIuQMETELsXG2YtbsAc8K3q/

Again, after inserting this String as is into the pgsql database, I can 
authenticate with dovecot.

Now the next step for me would be to be able to generate such SHA512 
hashes with pgsql myself.
I made two attempts:

1) select digest('testing123','sha512');
result:
  \x4120117b3190ba5e24044732b0b09aa9ed50eb1567705abcbfa78431a4e0a96b1152ed7f4925966b1c82325e186a8100e692e6d2fcb6702572765820d25c7e9e
login fails

2) select encode(digest('testing123','sha512'),'hex');
result:
  4120117b3190ba5e24044732b0b09aa9ed50eb1567705abcbfa78431a4e0a96b1152ed7f4925966b1c82325e186a8100e692e6d2fcb6702572765820d25c7e9e
login fails

How did you generate your hash and how can I do the same with pgsql?

Thanks
Magnus