Re: How to store Byte strings into a table.

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Trinath Somanchi <trinath(dot)somanchi(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to store Byte strings into a table.
Date: 2010-07-05 06:45:45
Message-ID: AANLkTimrNwHbiZmKWEO2oHtdE1z3l_onLAZW8oA5XkZX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 5 July 2010 09:57, Trinath Somanchi <trinath(dot)somanchi(at)gmail(dot)com> wrote:
> Hi,
>
> How can I store Byte strings into a postgresql database.
>
> Is there any special command to store it. How will be the sql query.
>
> I have gone through this
> http://www.postgresql.org/docs/8.4/static/datatype-binary.html but have not
> seen any example for how to insert data into such a field.

Use octet-escaping to form the string to put in your SQL like it
described it the article you referenced.

>
> Please help me in this regard.
>
>
> --
> Regards,
> ----------------------------------------------
> Trinath Somanchi,
>

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message silly sad 2010-07-05 06:56:38 Re:
Previous Message Pavel Stehule 2010-07-05 06:43:13 Re: