[FIXED] How do I convert a column of large objects to long text?

Issue

I'm using Spring Boot with Hibernate, JPA and PostgreSQL. I'm wanting to convert database large objects into text content. Previously I was defining my long text in my JPA entity as @Lob:

@Lob
String description;

I then discovered that often problems are created using @Lob's and decided to rather change them to:

@Type(type="org.hibernate.type.StringClobType")
String description;

Which is represented in the database as a text type. Unfortunately, now the reference numbers (oid's) of the previous large objects are stored in my rows instead of the actual content. For example:

id | description
---------------------
 1 | 463784           <- This is a reference to the object rather than the content

instead of:

id | description
---------------------
 1 | Once upon a time, in a galaxy...

My question is now that we have thousands of rows of data in the database, how do I write a function or perform a query to replace the large object id with the actual text content stored in the large object?

Solution

Special thanks to @BohuslavBurghardt for pointing me to this answer. For your convenience:

UPDATE table_name SET column_name = lo_get(cast(column_name as bigint))

Answered By - sparkyspider