Timeline for Get TEXT value of a CLOB OID in Postgresql
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 28, 2023 at 12:44 | comment | added | marioosh | I've used a little tweeked version: update answers set answer_value = convert_from(lo_get(cast(value as bigint)), 'UTF8') | |
| Jun 25, 2018 at 18:33 | comment | added | Freiheit | Documentation for lo_get is here: postgresql.org/docs/9.6/static/lo-funcs.html | |
| May 29, 2017 at 6:05 | history | edited | Andriy M | CC BY-SA 3.0 | improved formatting; incorporated the name of the commenter who suggested the solution |
| May 29, 2017 at 6:03 | comment | added | Andriy M | Perhaps it's because the correct function name is lo_read. | |
| Feb 4, 2015 at 14:22 | comment | added | John P | loread does not appear to be available to me as either postgres, or the database owner. "No function matches the given name and argument types" | |
| Feb 3, 2015 at 15:08 | comment | added | user1822 | Did you try loread()? postgresql.org/docs/9.0/static/lo-funcs.html | |
| Feb 3, 2015 at 15:01 | history | answered | John P | CC BY-SA 3.0 |