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
On 5 July 2010 09:57, Trinath Somanchi 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
> see
2010/7/5 silly sad :
> 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 f
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.
--
Sent via pgsql-sql mailing lis
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 :
> Hi,
>
> I'm new in using BLOB. How will the insert for storing very large byte
> strings into a column of
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 wrote:
> On 07/05/10 09:57, wrote:
>
>> Hi,
>>
>> How can I store Byte strings into a postgresql database.
>> Is there any special com
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
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.
Pleas
