Re: function digest(unknown, unknown) does not exist

[Ian Lawrence Barwick <barwick@xxxxxxxxx>]

2021年2月10日(水) 19:26 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

You probably need to install the pgcrypto extension, which contains this function [1]

[1] https://www.postgresql.org/docs/current/pgcrypto.html#id-1.11.7.34.6.2

 

Regards

Ian Barwick

--

EnterpriseDB: https://www.enterprisedb.com