unsubscribe psql-admin
Hi. Could someone please tell me how to convert a varchar to a bytea datatype.
I have a column which contains a number stored as a varchar. I have another column of
type bytea. I'm trying to insert the value of the varchar column in the bytea column,
but the conversion won't work.
Something
-Original Message-
From: Ian Barwick [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:36 PM
To: Dylan Milks; PostgreSQL (E-mail)
Subject: Re: [ADMIN] Casting varchar to bytea
On Friday 12 September 2003 20:39, Dylan Milks wrote:
Hi. Could someone please tell me how to convert
Hi. I've read some of the documentation on how to use use pgcrypto, but I still can't
seem to get it working properly.
All I want to do is encrypt a field (using the AES algorithm) before inserting into
the table, and consequently decrypt that same field when I pull it out.
Example (my table