Thread: Binary Large Data on Postgres

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

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.

> 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