HMAC postgres error - No function matches the given name and argument types

Question

I'm getting below error while using hmac method in postgres. Please help.

root@go=# SELECT HMAC('MyPassword','mykey','md5');
ERROR:  42883: function hmac(unknown, unknown, unknown) does not exist
LINE 1: SELECT HMAC('MyPassword','mykey','md5');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
LOCATION:  ParseFuncOrColumn, parse_func.c:523
Time: 0.703 ms

How did you load `pgcrypto`? – melpomene Mar 14 '18 at 07:10 — melpomene, Mar 14 '18 at 07:10

score 3 · Accepted Answer · answered Mar 14 '18 at 07:21

3

Two possibilities:

You never installed pgcrypto with CREATE EXTENSION.
You installed pgcrypto in a schema that is not on the search_path of database user root.

answered Mar 14 '18 at 07:21

Laurenz Albe

209,280
17
206
263

3

Thank you @Laurenz, i have added extension, it works. `CREATE EXTENSION IF NOT EXISTS "pgcrypto" SCHEMA public;` – Thavaprakash Swaminathan Mar 14 '18 at 13:48

HMAC postgres error - No function matches the given name and argument types

1 Answers1