From: | "Dylan Milks" <DMilks(at)greenridge(dot)ca> |
---|---|
To: | "PostgreSQL (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Casting varchar to bytea |
Date: | 2003-09-12 18:39:27 |
Message-ID: | 84D4D76946AC2F43AA9BDCD860DC667518C18D@voyager.greenridge-int.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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 like the following:
update webuser set ccnum = ccnumstring::bytea where userid=userid;
Any ideas how to do this?
Also, I have the PGCRYPTO module and I can't get the AES algorithm to decrypt properly. It will encrypt, but not decrypt. However, I can get the BLOWFISH algorithm to work in both directions. Can someone please give me an example of decrypting using the AES algorithm?
Thanks in advance.
Dylan
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Hampton | 2003-09-12 18:45:55 | Re: object creation date |
Previous Message | Roberson, Dusty (L:ops Unix Admin) | 2003-09-12 18:25:57 | Configure complaints: Installed libs/apps not found |