Re: Blowfish Encrypted String

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.