pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to store Byte strings into a table.
19+ messages / 6 participants
[nested] [flat]
* How to store Byte strings into a table.
@ 2010-07-05 05:57 Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:45 ` Re: How to store Byte strings into a table. Sergey Konoplev <gray.ru@gmail.com>
0 siblings, 2 replies; 19+ messages in thread
From: Trinath Somanchi @ 2010-07-05 05:57 UTC (permalink / raw)
To: pgsql-sql
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.
Please help me in this regard.
--
Regards,
----------------------------------------------
Trinath Somanchi,
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
@ 2010-07-05 06:12 ` silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
1 sibling, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-05 06:12 UTC (permalink / raw)
To: pgsql-sql
On 07/05/10 09:57, 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.
there is only '\0' byte incapable to input-output.
so u have to have it escaped at all costs _AND NOTHING MORE_.
"escaped" doesn't mean "prefixed with backslash"
("backslash method" cause a zero-byte to pass SQL parser an to be
actually stored, BUT
the output will be corrupted, because of this zero-byte will be actually
output)
You may use the BYTEA type
(similar to the TEXT but with different input-output) which effectively
escapes zero-byte and a lot of other completely harmless bytes as well
(probably to reach a better overhead)
Or you may introduce a pair of your own escape rules.
Unfortunately there are no way to influence The Pg Developers to get rid
of the nasty god damned CSTRING off the input/output operations.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-05 06:30 ` Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:35 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
0 siblings, 2 replies; 19+ messages in thread
From: Trinath Somanchi @ 2010-07-05 06:30 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
Hi,
I'm new in using BLOB. How will the insert for storing very large byte
strings into a column of data type Blob.
On Mon, Jul 5, 2010 at 11:42 AM, silly sad <sad@bankir.ru> wrote:
> On 07/05/10 09:57, 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.
>>
>
> there is only '\0' byte incapable to input-output.
> so u have to have it escaped at all costs _AND NOTHING MORE_.
>
> "escaped" doesn't mean "prefixed with backslash"
> ("backslash method" cause a zero-byte to pass SQL parser an to be actually
> stored, BUT
> the output will be corrupted, because of this zero-byte will be actually
> output)
>
> You may use the BYTEA type
> (similar to the TEXT but with different input-output) which effectively
> escapes zero-byte and a lot of other completely harmless bytes as well
> (probably to reach a better overhead)
>
> Or you may introduce a pair of your own escape rules.
>
> Unfortunately there are no way to influence The Pg Developers to get rid of
> the nasty god damned CSTRING off the input/output operations.
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Regards,
----------------------------------------------
Trinath Somanchi,
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
@ 2010-07-05 06:35 ` Pavel Stehule <pavel.stehule@gmail.com>
1 sibling, 0 replies; 19+ messages in thread
From: Pavel Stehule @ 2010-07-05 06:35 UTC (permalink / raw)
To: Trinath Somanchi <trinath.somanchi@gmail.com>; +Cc: silly sad <sad@bankir.ru>; pgsql-sql
Hello
use a LO interface
http://www.postgresql.org/docs/8.4/static/lo-interfaces.html
exact form depends on language that you are use.
Regards
Pavel Stehule
2010/7/5 Trinath Somanchi <trinath.somanchi@gmail.com>:
> Hi,
>
> I'm new in using BLOB. How will the insert for storing very large byte
> strings into a column of data type Blob.
>
> On Mon, Jul 5, 2010 at 11:42 AM, silly sad <sad@bankir.ru> wrote:
>>
>> On 07/05/10 09:57, 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.
>>
>> there is only '\0' byte incapable to input-output.
>> so u have to have it escaped at all costs _AND NOTHING MORE_.
>>
>> "escaped" doesn't mean "prefixed with backslash"
>> ("backslash method" cause a zero-byte to pass SQL parser an to be actually
>> stored, BUT
>> the output will be corrupted, because of this zero-byte will be actually
>> output)
>>
>> You may use the BYTEA type
>> (similar to the TEXT but with different input-output) which effectively
>> escapes zero-byte and a lot of other completely harmless bytes as well
>> (probably to reach a better overhead)
>>
>> Or you may introduce a pair of your own escape rules.
>>
>> Unfortunately there are no way to influence The Pg Developers to get rid
>> of the nasty god damned CSTRING off the input/output operations.
>>
>>
>> --
>> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-sql
>
>
>
> --
> Regards,
> ----------------------------------------------
> Trinath Somanchi,
>
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
@ 2010-07-05 06:36 ` silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
1 sibling, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-05 06:36 UTC (permalink / raw)
To: pgsql-sql
On 07/05/10 10:30, Trinath Somanchi wrote:
> Hi,
>
> I'm new in using BLOB. How will the insert for storing very large byte
> strings into a column of data type Blob.
i didn't advice you to use BLOB.
you may store a string as long as 2GB at any TEXT or BYTEA field.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-05 06:43 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Pavel Stehule @ 2010-07-05 06:43 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
2010/7/5 silly sad <sad@bankir.ru>:
> On 07/05/10 10:30, Trinath Somanchi wrote:
>>
>> Hi,
>>
>> I'm new in using BLOB. How will the insert for storing very large byte
>> strings into a column of data type Blob.
>
> i didn't advice you to use BLOB.
>
> you may store a string as long as 2GB at any TEXT or BYTEA field.
you can do it, but don't do it! Escaping of large strings are not
cheap, processing extra long SQL statements are extreme expensive on
memory - so don't do it - or test it before and check memory and
processor usage - and check it in testing environment with more than
one user.
The good size for text or bytea is less than 100M and real max isn't
2G but it is 1G. LO isn't these limits because it isn't accessable on
SQL level.
Regards
Pavel Stehule
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
@ 2010-07-05 06:56 ` silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-05 06:56 UTC (permalink / raw)
To: pgsql-sql
On 07/05/10 10:43, Pavel Stehule wrote:
> The good size for text or bytea is less than 100M and real max isn't
> 2G but it is 1G. LO isn't these limits because it isn't accessable on
> SQL level.
any regular file on my filesystem isn't accessible on SQL level.
i am happy with them and never tried to store at a database.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-05 07:03 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Pavel Stehule @ 2010-07-05 07:03 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
2010/7/5 silly sad <sad@bankir.ru>:
> On 07/05/10 10:43, Pavel Stehule wrote:
>
>> The good size for text or bytea is less than 100M and real max isn't
>> 2G but it is 1G. LO isn't these limits because it isn't accessable on
>> SQL level.
>
> any regular file on my filesystem isn't accessible on SQL level.
> i am happy with them and never tried to store at a database.
this is second extreme - you can use everything if you know what you
do - and mainly it depends on applications and requests that you have
to solve.
Pavel
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
@ 2010-07-05 07:10 ` silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-05 07:10 UTC (permalink / raw)
To: Pavel Stehule <pavel.stehule@gmail.com>; +Cc: pgsql-sql
On 07/05/10 11:03, Pavel Stehule wrote:
> 2010/7/5 silly sad<sad@bankir.ru>:
>> On 07/05/10 10:43, Pavel Stehule wrote:
>>
>>> The good size for text or bytea is less than 100M and real max isn't
>>> 2G but it is 1G. LO isn't these limits because it isn't accessable on
>>> SQL level.
>>
>> any regular file on my filesystem isn't accessible on SQL level.
>> i am happy with them and never tried to store at a database.
>
> this is second extreme - you can use everything if you know what you
> do - and mainly it depends on applications and requests that you have
> to solve.
the trouble is the initiator of the thread didn't determine what is his
problem either storing of a zero-byte containing string or storing of
huge strings.
I answered him about BYTEA and he replied about BLOB.
I only tried to say i didn't say a word about BLOB.
P.S.
Practically for storing pictures i prefer regular files.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-05 07:18 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Pavel Stehule @ 2010-07-05 07:18 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
2010/7/5 silly sad <sad@bankir.ru>:
> On 07/05/10 11:03, Pavel Stehule wrote:
>>
>> 2010/7/5 silly sad<sad@bankir.ru>:
>>>
>>> On 07/05/10 10:43, Pavel Stehule wrote:
>>>
>>>> The good size for text or bytea is less than 100M and real max isn't
>>>> 2G but it is 1G. LO isn't these limits because it isn't accessable on
>>>> SQL level.
>>>
>>> any regular file on my filesystem isn't accessible on SQL level.
>>> i am happy with them and never tried to store at a database.
>>
>> this is second extreme - you can use everything if you know what you
>> do - and mainly it depends on applications and requests that you have
>> to solve.
>
> the trouble is the initiator of the thread didn't determine what is his
> problem either storing of a zero-byte containing string or storing of huge
> strings.
> I answered him about BYTEA and he replied about BLOB.
> I only tried to say i didn't say a word about BLOB.
yes
>
> P.S.
> Practically for storing pictures i prefer regular files.
>
how I say - it depends on application - sometime can be useful have to
access to all data only from db connect - for million small pictures
the bytea can be best.
Pavel
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
@ 2010-07-05 07:28 ` silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
0 siblings, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-05 07:28 UTC (permalink / raw)
To: pgsql-sql
On 07/05/10 11:18, Pavel Stehule wrote:
>> P.S.
>> Practically for storing pictures i prefer regular files.
>>
>
> how I say - it depends on application - sometime can be useful have to
> access to all data only from db connect - for million small pictures
> the bytea can be best.
i really love postgres TEXT type, but i hate CSTRING input-output
bottleneck.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-05 07:51 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
0 siblings, 1 reply; 19+ messages in thread
From: Pavel Stehule @ 2010-07-05 07:51 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
2010/7/5 silly sad <sad@bankir.ru>:
> On 07/05/10 11:18, Pavel Stehule wrote:
>
>>> P.S.
>>> Practically for storing pictures i prefer regular files.
>>>
>>
>> how I say - it depends on application - sometime can be useful have to
>> access to all data only from db connect - for million small pictures
>> the bytea can be best.
>
> i really love postgres TEXT type, but i hate CSTRING input-output
why?
and it isn't true - you can use a binary interface of PQexecParams -
minimally for text and bytea it is very simple
Pavel
> bottleneck.
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
@ 2010-07-06 17:52 ` Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Justin Graf @ 2010-07-06 17:52 UTC (permalink / raw)
To: Pavel Stehule <pavel.stehule@gmail.com>; +Cc: silly sad <sad@bankir.ru>; pgsql-sql
I wrote an article covering this on the wiki
http://wiki.postgresql.org/wiki/BinaryFilesInDB
I need to update to for 9.0 as bytea now allows HEX format strings
http://developer.postgresql.org/pgdocs/postgres/datatype-binary.html
All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.
CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately.
Thank you.
Attachments:
[text/x-vcard] justin.vcf (271B, ../../4C336D73.2000105@magwerks.com/2-justin.vcf)
download | inline:
begin:vcard
fn:Justin Graf
n:Graf;Justin
org:Magwerks Corp
adr:;;501 Commerce Drive;Danville ;IN;46122;USA
email;internet:justin@magwerks.com
tel;work:317-241-8011 ext 703
tel;fax:317-241-8015
x-mozilla-html:FALSE
url:www.magwerks.com
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
@ 2010-07-07 05:00 ` silly sad <sad@bankir.ru>
2010-07-07 14:35 ` Re: Justin Graf <justin@magwerks.com>
0 siblings, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-07 05:00 UTC (permalink / raw)
To: pgsql-sql
On 07/06/10 21:52, Justin Graf wrote:
> I wrote an article covering this on the wiki
>
> http://wiki.postgresql.org/wiki/BinaryFilesInDB
there are some "red flags" in communication
(particularly reading papers)
one of them is "binary data" which ITSELF IS NONSENCE.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-07 14:35 ` Justin Graf <justin@magwerks.com>
2010-07-08 07:31 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Justin Graf @ 2010-07-07 14:35 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: pgsql-sql
On 7/7/2010 12:00 AM, silly sad wrote:
> On 07/06/10 21:52, Justin Graf wrote:
>
>> I wrote an article covering this on the wiki
>>
>> http://wiki.postgresql.org/wiki/BinaryFilesInDB
>>
> there are some "red flags" in communication
> (particularly reading papers)
> one of them is "binary data" which ITSELF IS NONSENCE.
>
WHAT???????
You do understand that if you don't like it you can spend time fixing it.
All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.
CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately.
Thank you.
Attachments:
[text/x-vcard] justin.vcf (271B, ../../4C3490B4.6060903@magwerks.com/2-justin.vcf)
download | inline:
begin:vcard
fn:Justin Graf
n:Graf;Justin
org:Magwerks Corp
adr:;;501 Commerce Drive;Danville ;IN;46122;USA
email;internet:justin@magwerks.com
tel;work:317-241-8011 ext 703
tel;fax:317-241-8015
x-mozilla-html:FALSE
url:www.magwerks.com
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
2010-07-07 14:35 ` Re: Justin Graf <justin@magwerks.com>
@ 2010-07-08 07:31 ` silly sad <sad@bankir.ru>
2010-07-08 07:38 ` Re: Dave Page <dpage@postgresql.org>
0 siblings, 1 reply; 19+ messages in thread
From: silly sad @ 2010-07-08 07:31 UTC (permalink / raw)
To: Justin Graf <justin@magwerks.com>; +Cc: pgsql-sql
On 07/07/10 18:35, Justin Graf wrote:
> On 7/7/2010 12:00 AM, silly sad wrote:
>> On 07/06/10 21:52, Justin Graf wrote:
>>
>>> I wrote an article covering this on the wiki
>>>
>>> http://wiki.postgresql.org/wiki/BinaryFilesInDB
>>>
>> there are some "red flags" in communication
>> (particularly reading papers)
>> one of them is "binary data" which ITSELF IS NONSENCE.
>>
>
> WHAT???????
>
> You do understand that if you don't like it you can spend time fixing it.
fix what? human minds of so-called programmers?
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
2010-07-07 14:35 ` Re: Justin Graf <justin@magwerks.com>
2010-07-08 07:31 ` Re: silly sad <sad@bankir.ru>
@ 2010-07-08 07:38 ` Dave Page <dpage@postgresql.org>
2010-07-08 08:47 ` Re: silly sad <sad@bankir.ru>
0 siblings, 1 reply; 19+ messages in thread
From: Dave Page @ 2010-07-08 07:38 UTC (permalink / raw)
To: silly sad <sad@bankir.ru>; +Cc: Justin Graf <justin@magwerks.com>; pgsql-sql
On Thu, Jul 8, 2010 at 8:31 AM, silly sad <sad@bankir.ru> wrote:
> On 07/07/10 18:35, Justin Graf wrote:
>>
>> On 7/7/2010 12:00 AM, silly sad wrote:
>>>
>>> On 07/06/10 21:52, Justin Graf wrote:
>>>
>>>> I wrote an article covering this on the wiki
>>>>
>>>> http://wiki.postgresql.org/wiki/BinaryFilesInDB
>>>>
>>> there are some "red flags" in communication
>>> (particularly reading papers)
>>> one of them is "binary data" which ITSELF IS NONSENCE.
>>>
>>
>> WHAT???????
>>
>> You do understand that if you don't like it you can spend time fixing it.
>
> fix what? human minds of so-called programmers?
That is not appropriate behaviour for the PostgreSQL mailing lists.
Please treat others with respect, even if you disagree with them.
--
Dave Page
PostgreSQL Core Team
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re:
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
2010-07-07 14:35 ` Re: Justin Graf <justin@magwerks.com>
2010-07-08 07:31 ` Re: silly sad <sad@bankir.ru>
2010-07-08 07:38 ` Re: Dave Page <dpage@postgresql.org>
@ 2010-07-08 08:47 ` silly sad <sad@bankir.ru>
0 siblings, 0 replies; 19+ messages in thread
From: silly sad @ 2010-07-08 08:47 UTC (permalink / raw)
To: pgsql-sql
On 07/08/10 11:38, Dave Page wrote:
> On Thu, Jul 8, 2010 at 8:31 AM, silly sad<sad@bankir.ru> wrote:
>> On 07/07/10 18:35, Justin Graf wrote:
>>>
>>> On 7/7/2010 12:00 AM, silly sad wrote:
>>>>
>>>> On 07/06/10 21:52, Justin Graf wrote:
>>>>
>>>>> I wrote an article covering this on the wiki
>>>>>
>>>>> http://wiki.postgresql.org/wiki/BinaryFilesInDB
>>>>>
>>>> there are some "red flags" in communication
>>>> (particularly reading papers)
>>>> one of them is "binary data" which ITSELF IS NONSENCE.
>>>>
>>>
>>> WHAT???????
>>>
>>> You do understand that if you don't like it you can spend time fixing it.
>>
>> fix what? human minds of so-called programmers?
>
> That is not appropriate behaviour for the PostgreSQL mailing lists.
> Please treat others with respect, even if you disagree with them.
i do not disagree.
i only meant a fixing of human communication problem is out of my hand.
^ permalink raw reply [nested|flat] 19+ messages in thread
* Re: How to store Byte strings into a table.
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
@ 2010-07-05 06:45 ` Sergey Konoplev <gray.ru@gmail.com>
1 sibling, 0 replies; 19+ messages in thread
From: Sergey Konoplev @ 2010-07-05 06:45 UTC (permalink / raw)
To: Trinath Somanchi <trinath.somanchi@gmail.com>; +Cc: pgsql-sql
On 5 July 2010 09:57, Trinath Somanchi <trinath.somanchi@gmail.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.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802
^ permalink raw reply [nested|flat] 19+ messages in thread
end of thread, other threads:[~2010-07-08 08:47 UTC | newest]
Thread overview: 19+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-05 05:57 How to store Byte strings into a table. Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:12 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:30 ` Re: Trinath Somanchi <trinath.somanchi@gmail.com>
2010-07-05 06:35 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:36 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:43 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 06:56 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:03 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:10 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:18 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-05 07:28 ` Re: silly sad <sad@bankir.ru>
2010-07-05 07:51 ` Re: Pavel Stehule <pavel.stehule@gmail.com>
2010-07-06 17:52 ` Re: Justin Graf <justin@magwerks.com>
2010-07-07 05:00 ` Re: silly sad <sad@bankir.ru>
2010-07-07 14:35 ` Re: Justin Graf <justin@magwerks.com>
2010-07-08 07:31 ` Re: silly sad <sad@bankir.ru>
2010-07-08 07:38 ` Re: Dave Page <dpage@postgresql.org>
2010-07-08 08:47 ` Re: silly sad <sad@bankir.ru>
2010-07-05 06:45 ` Sergey Konoplev <gray.ru@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox