How can I get access to password hashing in postgresql? Tried installing postgresql-contrib in ubuntu, still can't access hashing functions
Solution 1:
This may be a hint, from one of the web pages you listed above:
Many modules supply new user-defined functions, operators, or types. To make use of one of these modules, after you have installed the code you need to register the new objects in the database system by running the SQL commands in the .sql file supplied by the module. For example,
psql -d dbname -f SHAREDIR/contrib/module.sql
Solution 2:
After you install postgresql-contrib you need to run CREATE EXTENSION pgcrypto;
against the db where you want to use the crypto functions
Solution 3:
Much easier Just install pdAdmin and from the database you are working on right click on the database and ADD NEW OBJECT select Extension then select pgcrypto for name and set the definition schema to public and version 1.0 WORKED AS A CHARM FOR ME ON MY MAC OS 10.7.5 using Postgres 9.2