FAQ
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.

Search Discussions

  • Peter Eisentraut at May 3, 2001 at 3:53 pm

    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
  • Vladislav Breus at May 4, 2001 at 6:26 am
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedMay 3, '01 at 1:56p
activeMay 4, '01 at 6:26a
posts3
users2
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase