From: | "David Patricola" <david(dot)patricola(at)jefferson(dot)edu> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Pgcrypto install (I've tried multiple ways) |
Date: | 2011-01-27 23:22:49 |
Message-ID: | 644B0A17922F435A829C22FBFF9CE9AD@tjumst.jefferson.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Actually, what is bytea in terms of type, or rather, what types of database
fields will this work with? The field I'm calling from the table is varchar
(the encrypt function worked find for this).
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, January 27, 2011 6:15 PM
To: David Patricola
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-27 23:34:04 | Re: Pgcrypto install (I've tried multiple ways) |
Previous Message | Tom Lane | 2011-01-27 23:15:02 | Re: Pgcrypto install (I've tried multiple ways) |