Re: Pgcrypto install (I've tried multiple ways)

"David Patricola" <david(dot)patricola(at)jefferson(dot)edu> writes:
> I ran the script under database 'testdb', and that's the database I'm
> viewing when in pgAdmin. Here's what \df decript gave me:

> Schema | Name | Result data type | Argument data types | Type
> -------+---------+------------------+---------------------+--------
> public | decrypt | bytea | bytea, bytea, text | normal

> (it finds all of the functions, in fact)

> However, when I run this query it says it can't find the function with the
> given name and datatypes.

> select decrypt(thenotes, 'thekey', 'aes') AS theoutput
> from footable

So is "thenotes" of type bytea?

regards, tom lane