Обсуждение: function digest(iso-8859-1, iso-8859-1) does not exist
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
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@gmail.com
2021年2月10日(水) 19:26 dbatoCloud Solution <dbatocloud17@gmail.com>:
Hi All,While executing this below function I'm facing this error.Let me know if someone had the same issue in postgresql 10.xERROR: 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: 42883Character: 15
You probably need to install the pgcrypto extension, which contains this function [1]
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com