PostgreSQL and BLOB/Large Objects

Note: please leave bug reports and feature requests on

PostgreSQL and BLOB/Large Objects

Postby jhack » Tue Apr 19, 2016 3:04 pm

As far as I know, BLOBs/LOBs can be stored in two ways: using "bytea" and "OID" types. However, it seems that also "text" type is supported, using the column to store a number (as string), which refers to the LOB.
bytea seems to be supported by DBeaver.
Are "text" and "OID" types supported? How can I insert and retrieve data stored in such a way?

Thanks in advance,
J
jhack
 
Posts: 2
Joined: Mon Apr 18, 2016 10:12 pm

Re: PostgreSQL and BLOB/Large Objects

Postby Serge » Tue Apr 19, 2016 8:11 pm

I don't know about this second way to store LOBs.
OID is just a pseudo column which can be used instead of primary key. How is it related to LOBs?
Can you post an example of table DDL?
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: PostgreSQL and BLOB/Large Objects

Postby jhack » Tue Apr 19, 2016 8:21 pm

You can find an explanation and an example here and here .
jhack
 
Posts: 2
Joined: Mon Apr 18, 2016 10:12 pm


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 16 guests