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
Last activity: Feb 13, 2019, 04:49 PM