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/