> 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.