How to install pgcrypto module on a postgres DB

Question

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!

Answer 1

Using PSQL or PgAdmin, connect to the DB and type

CREATE EXTENSION IF NOT EXISTS pgcrypto;