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

"David Patricola" <david.patricola@jefferson.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