Sample Header Ad - 728x90

How do I install pgcrypto in PostgreSQL 8.4?

24 votes
3 answers
59440 views
I'm using Ubuntu Server 10.10 and I have installed PostgreSQL 8.4 using apt-get install postgresql. I would like to use the built-in sha1() function, but it seems that I have to install pgcrypto first. But I don't know how to install it. There is no pgcrypto if I try to install it using apt-get install pgcrypto and I don't find any files starting with pgcrypto in my system (I tried find / -name "pgcrypto*"). How do I install pgcrypto so I can use the digest('word-to-hash','sha1') function in my database queries? ------------- **Update:** I'm struggling to install pgcrypto on another Ubuntu machine. After installing the package using sudo apt-get install postgresql-contrib-8.4 how do I install it to my current PostgreSQL database?
Asked by Jonas (33975 rep)
Mar 24, 2011, 01:58 PM
Last activity: Feb 13, 2019, 04:49 PM