Monday, January 29, 2024

[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)