In RDS digest function is undefined after creating pgcrypto extension

5 votes

1 answer

2544 views

                          On an AWS RDS instance, we have run

    CREATE EXTENSION pgcrypto;

The extension gets created.  Both queries:

    SELECT digest('a', 'sha256') FROM table_name;
    SELECT public.digest('a', 'sha256') FROM table_name;

Gives the error **function public.digest(unknown, unknown) does not exist**

Asked by chris (201 rep)

Apr 12, 2016, 06:49 PM
Last activity: May 13, 2019, 06:02 PM

In RDS digest function is undefined after creating pgcrypto extension

Related Questions