BLOB type
Started by Vladislav Breusalmost 25 years ago3 messagesgeneral
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.
Re: BLOB type
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
Re: BLOB type
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:
Show quoted text
Vladislav Breus writes:
Has PostgreSQL the data type such ORACLE BLOB type ?
bytea is for storing binary data.