| From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Bytea datatype content to view |
| Date: | 2024-11-07 09:08:05 |
| Message-ID: | CAB5fag53WHfrGk538+d2uMCdjjdaRskN_4anx4RMo-nFC0F4RQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thanks everyone for your valuable inputs.
On Wed, 6 Nov, 2024, 9:33 pm Alvaro Herrera, <alvherre(at)alvh(dot)no-ip(dot)org>
wrote:
> 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/
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wasim Devale | 2024-11-07 09:16:26 | ON CONFLICT Clause used on partition tables |
| Previous Message | Edwin UY | 2024-11-07 07:49:56 | Re: \i and \watch |