Postgres Pro
Downloads
Home   >   mailing lists

Re: Binary Large Data on Postgres - Mailing list pgsql-general

From David Wall
Subject Re: Binary Large Data on Postgres
Date
Msg-id 018a01c0aca2$8c63bd00$5a2b7ad8@expertrade.com
Whole thread Raw
In response to Binary Large Data on Postgres  ("Torsten Krämer" <tk@kreakom.de>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: Re: Timestamp interval question
Next
From:
Date:
Subject: re : Please Help