[SOLVED] How to install pgcrypto module on a postgres DB

Issue

I have Postgres version 10.5 from the docker hub and don't know how to install the pgcrypto module. In /usr/lib/postgresql/10/lib# there is a pgcrypto.so file. What to do with that file? I can't find documentation about it, thanks for your help!

Solution

Using PSQL or PgAdmin, connect to the DB and type

CREATE EXTENSION IF NOT EXISTS pgcrypto;

Answered By - JGH

Answer Checked By - Willingham (WPSolving Volunteer)