Skip site navigation (1) Skip section navigation (2)

Pgcrypto install (I've tried multiple ways)

From: "David Patricola" <david(dot)patricola(at)jefferson(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Pgcrypto install (I've tried multiple ways)
Date: 2011-01-27 21:31:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I'm not sure what I'm doing wrong here.  I've tried to install the pgcrypto
module from:


1.	psql shell: i\ path/to/pgcrypto.sql
2.	pgAdmin: execute pgScript pgcrypto.sql


Both showed me multiple lines of CREATE FUNCTION with no other errors.
However, when I try to test the decrypt() function it says it doesn't exist.
Encrypt() has worked fine, even before the module install.  Stopping and
starting the service doesn't help.


I'm running pgAdmin 1.12 with Postgresql 9.0 installed on Windows 2003.


David Patricola | Senior Cold Fusion Developer | Web Applications & Services
| Jefferson Information Technologies


Thomas Jefferson Universtiy | Philadelphia, PA | 215.503.1715 (Office)



pgsql-novice by date

Next:From: Tom LaneDate: 2011-01-27 21:44:42
Subject: Re: Pgcrypto install (I've tried multiple ways)
Previous:From: Josh KupershmidtDate: 2011-01-27 04:10:34
Subject: Re: new to postgreSql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group