PostgreSQL and BLOB/Large Objects

[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

[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?

[jhack]

You can find an explanation and an example here and here .