function digest(unknown, unknown) does not exist

[dbatoCloud Solution <dbatocloud17@xxxxxxxxx>]

Hi All,

While executing this below function I'm facing this error. 

Let me know if someone had the same issue in postgresql 10.x

ERROR:  function digest(unknown, unknown) does not exist
LINE 1: select encode(digest('123', 'sha256'),'hex');
                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883

Character: 15

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx