I would like to install
pgcrypto in Windows. I have a file
C:\Program\PostgreSQL\9.0\share\contrib\pgcrypto.sql but when I try to run it in
psql I get an error:
C:: Permission denied
How do I solve this?
Depending on the full error message you receive (I have a hunch you didn't post it in full) you probably are trying to run the script by using a login role which is not superuser: