2013/9/26 Craig Boyd <craigboyd0@xxxxxxxxx>
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.
