I come from MySQL and I am new for 'PostgreSQL World'.
I need to hashing a password with the crypt() function. My query is:
UPDATE public.accounts SET account_hash = crypt('hello', gen_salt('md5'));
where account_hash is a charatcter data type.
The SQL error is:
ERROR: function gen_salt(unknown) does not exist
LINE 1: ... public.accounts SET account_hash = crypt('cane', gen_salt('...
HINT: No function matches the given name and argument types. You might need to add explicit type casts.