Installing pgcrypto Extension 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; 


I get 

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)?
I'm assuming that you want to create this extension in another server. I'm guessing that the server didn't get the "postgresql contrib" package installed. This package contains the "standard" extensions that are available from the PostgreSQL source code.

I think you need to get the system administrator to install the required package for your OS.

For Debian and Ubuntu it's the "postgresql-contrib-9.1" package, for other platforms it has a similar name.