On Monday 21 January 2019 15:03:23 Gary Stainburn wrote:
> After doing this the install worked perfectly. However, when I try to use
> the crypt() function I get the following error. I can't see what I've
> missed
>
> users=# select crypt('password','myhash');
> ERROR: function crypt(unknown, unknown) does not exist
> LINE 1: select crypt('password','myhash');
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> users=#
Sory folks, just found the answer. I need to run
create extension pgcrypto;
in each of my databases