I have this password hash function that hashes a password to sha256. I've already got it running in pgadmin3 in a local database. I've done it by importing the extension, a feature that has been added a few versions ago.
To my schoolwork I need to run the trigger in a phppgadmin server but when I execute
CREATE EXTENSION pgcrypto;
ERROR: could not open extension control file "/usr/share/postgresql/9.1/extension/pgcrypto.control": No such file or directory
How can I resolve this without having to change my hash to a weaker one (md5 or sha1)?