Q: What is the reason I get 'ERROR: Function digest(character varying) does not exist' on PostgreSQL?

A:

This means that your PostgreSQL installation does not have the digest> procedure available.

If you use RPMS (Redhat and Mandrake) install the postgresql-contrib package.

You must then install the procedure by running this shell command:




psql [dbname] < /usr/share/pgsql/contrib/pgcrypto.sql

Where [dbname] is the name of the database.

Note: You should make sure you run this as the postgres user.

Back to Database

7x

Share your information

Main menu

Sub menu

Products

Path

Q: What is the reason I get 'ERROR: Function digest(character varying) does not exist' on PostgreSQL?

A:

FAQ categories