On Sep 26, 2013, at 10:55 AM, Craig Boyd <craigboyd0@xxxxxxxxx> wrote: > 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. > http://www.postgresql.org/docs/devel/static/datatype-binary.html Most client libraries will have functionality to do this nicely (e.g. sending a Java byte[] to a Postgres bytea); it sucks somewhat to do it by hand in SQL. > Thanks, > > Craig Boyd > > > On Thu, Sep 26, 2013 at 11:46 AM, Dmitriy Igrishin <dmitigr@xxxxxxxxx> wrote: > > > > 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. > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
