Postgres Pro
Downloads
Home   >   mailing lists

Re: Blowfish Encrypted String - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Blowfish Encrypted String
Date
Msg-id CAAfz9KOgBg2d3EzZnCOg0RSOmp9qoaFdcopTi3ePo+KH2hJFiQ@mail.gmail.com
Whole thread Raw
In response to Blowfish Encrypted String  (Craig Boyd <craigboyd0@gmail.com>)
Responses Re: Blowfish Encrypted String
List pgsql-general
Tree view



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: Rob Richardson
Date:
Subject: Re: How do I find a trigger function that is raising notices?
Next
From: Laura Tateosian
Date:
Subject: Trouble installing psycopg2