Re: function digest(iso-8859-1, iso-8859-1) does not exist - Mailing list pgsql-admin

From Ian Lawrence Barwick
Subject Re: function digest(iso-8859-1, iso-8859-1) does not exist
Date
Msg-id CAB8KJ=jjEkvRcp4En+Wrdsz4=AZrrdFv7tuiybJh_xNhd4uhwg@mail.gmail.com
Whole thread Raw
In response to function digest(iso-8859-1, iso-8859-1) does not exist  (dbatoCloud Solution <dbatocloud17@gmail.com>)
List pgsql-admin
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.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]


 
Regards

Ian Barwick

pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: function digest(iso-8859-1, iso-8859-1) does not exist
Next
From: Pepe TD Vo
Date:
Subject: setup replica master slave in AWS Linux 2