Page 1 of 1

PostgreSQL and BLOB/Large Objects

PostPosted: Tue Apr 19, 2016 3:04 pm
by jhack
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

Re: PostgreSQL and BLOB/Large Objects

PostPosted: Tue Apr 19, 2016 8:11 pm
by Serge
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?

Re: PostgreSQL and BLOB/Large Objects

PostPosted: Tue Apr 19, 2016 8:21 pm
by jhack
You can find an explanation and an example here and here .