Postgres Pro
Downloads
Home   >   mailing lists

Re: Blowfish Encrypted String - Mailing list pgsql-general

From Craig Boyd
Subject Re: Blowfish Encrypted String
Date
Msg-id CAN-eDDu8fz2tWmSuC94rtO7rViLo6K=_5CuRn8WCMLCYmDPZuQ@mail.gmail.com
Whole thread Raw
In response to Re: Blowfish Encrypted String  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: Blowfish Encrypted String  (Steven Schlansker <steven@likeness.com>)
List pgsql-general
Tree view
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@gmail.com> wrote:



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


pgsql-general by date:

Previous
From: Laura Tateosian
Date:
Subject: Trouble installing psycopg2
Next
From: David Kerr
Date:
Subject: Re: Trouble installing psycopg2