Thread: BLOB type

Has PostgreSQL the data type such ORACLE BLOB type ?

(BLOB: A binary large object. Maximum size is 4 gigabytes.)

I have about 200-300 binary files (with size less then 1-2 MB),
which I need storage in DB.

Vladislav Breus writes:

> Has PostgreSQL the data type such ORACLE BLOB type ?

bytea is for storing binary data.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Can I use UPDATE or INSERT to store data this type, or I must
use lo_import or lo_export ONLY?

for ex.

%insert into test (col) ('<--- binary data --->');

Is it possible ?

Peter Eisentraut wrote:
>
> Vladislav Breus writes:
>
> > Has PostgreSQL the data type such ORACLE BLOB type ?
>
> bytea is for storing binary data.