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!

JGH · Accepted Answer · 2018-10-04 00:45:02Z

62

Using PSQL or PgAdmin, connect to the DB and type

CREATE EXTENSION IF NOT EXISTS pgcrypto;

answered Oct 4, 2018 at 0:45

JGH

18.2k5 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Egor123412 · Accepted Answer · 2024-01-22 09:12:56Z

2

Actually make sure to force SET search_path='required_schema'; (usually public). Otherwise "CREATE EXTENSION IF NOT EXISTS pgcrypto;" command will install pgcrypto functions to the first schema in search path of the current user.

answered Jan 22, 2024 at 9:12

Egor123412

362 bronze badges

Collectives™ on Stack Overflow

How to install pgcrypto module on a postgres DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related