Re: Blowfish Encrypted String

Dmitriy,

Thank you very much for the reply!

Right...got the the data type...but how do I actually insert a binary
string into the column? What does the SQL look like?
For the moment assume I have the following bit of binary: 4PO„âÔ™ä²

What does the SQL look like to insert that into the bytea column?
(FYI...most of my binary data would be only slightly bigger than what I
just pasted here. I am not storing Word documents or images, just some
encrypted strings of test that are not more than 100 characters long and
typically about 16 to 20.

Thanks,

Craig Boyd

On Thu, Sep 26, 2013 at 11:46 AM, Dmitriy Igrishin <dmitigr(at)gmail(dot)com>wrote:

>
>
>
> 2013/9/26 Craig Boyd <craigboyd0(at)gmail(dot)com>
>
>> Hello All,
>>
>> I have a string in a program that I have encrypted using Blowfish and I
>> am now trying to figure out the best way to store that in PostgreSQL so
>> that I can store it and retrieve it later for decryption. I have searched
>> around and have not found some good examples of how to go about this.
>>
>> So my first questions is: Can someone point me to a tutorial or posting
>> that shows how one might do that?
>>
>> Failing that:
>> What data type should I use to store this?
>>
> I believe that you should use bytea datatype.
>
>> What does the SQL look like to INSERT/SELECT the field?
>>
> Just like any other INSERT/SELECT query.
>
>
> --
> // Dmitriy.
>
>