From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
---|---|
To: | dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: function digest(unknown, unknown) does not exist |
Date: | 2021-02-10 11:04:45 |
Message-ID: | CAB8KJ=jjEkvRcp4En+Wrdsz4=AZrrdFv7tuiybJh_xNhd4uhwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2021年2月10日(水) 19:26 dbatoCloud Solution <dbatocloud17(at)gmail(dot)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]
[1] https://www.postgresql.org/docs/current/pgcrypto.html#id-1.11.7.34.6.2
Regards
Ian Barwick
--
EnterpriseDB: https://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Pepe TD Vo | 2021-02-10 13:22:09 | setup replica master slave in AWS Linux 2 |
Previous Message | dbatoCloud Solution | 2021-02-10 10:26:36 | function digest(unknown, unknown) does not exist |