On 2024-Nov-06, Wasim Devale wrote:

> Hi All
>
> I have a table having bytea datatype. Anyone has worked on it how we can
> see the content as the files are in .csv, .pdf, .bin and .docx format.

In a pinch, you could turn the bytea column into an LO using the
lo_from_bytea() function and use psql's \lo_export.  Quick and easy, no
need to write any code.

--
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/