Thread: Binary Large Data on Postgres

Binary Large Data on Postgres

From
"Torsten Krämer"
Date:
Hello,

i want to store my binary data such as Images,PDFs etc. in a database.
In Postgres doesn't exists the data type BLOB.
So i Have to store it an text field, haven't i ?
How long can a text field be?

thanks





Re: Binary Large Data on Postgres

From
jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Torsten Krämer <tk@kreakom.de> wrote:
>i want to store my binary data such as Images,PDFs etc. in a database.
>In Postgres doesn't exists the data type BLOB.

Have a look at
http://www.postgresql.org/users-lounge/docs/7.0/postgres/largeobjects.htm

HTH,
Ray
--
A Microsoft Certified System Engineer is to information technology as a
McDonalds Certified Food Specialist is to the culinary arts.
    Michael Bacarella commenting on the limited value of certification.

Re: Binary Large Data on Postgres

From
"David Wall"
Date:
> i want to store my binary data such as Images,PDFs etc. in a database.
> In Postgres doesn't exists the data type BLOB.
> So i Have to store it an text field, haven't i ?
> How long can a text field be?

Use datatype OID for blobs.  If you also use JDBC, then use the
setBytes()/getBytes() method to store/retrieve the blob.

David