MIME-Version: 1.0
References: 
 <CAB5fag593g9wK+hDdWDqRDUnd-N1XLAFNaGKv37F95LngkvdgQ@mail.gmail.com>
 <202411061603.rile4w5i3ugo@alvherre.pgsql>
In-Reply-To: <202411061603.rile4w5i3ugo@alvherre.pgsql>
From: Wasim Devale <wasimd60@gmail.com>
Date: Thu, 7 Nov 2024 14:38:05 +0530
Message-ID: 
 <CAB5fag53WHfrGk538+d2uMCdjjdaRskN_4anx4RMo-nFC0F4RQ@mail.gmail.com>
Subject: Re: Bytea datatype content to view
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: pgsql-admin <pgsql-admin@postgresql.org>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000091a31a06264ef9c2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB5fag53WHfrGk538%2Bd2uMCdjjdaRskN_4anx4RMo-nFC0F4RQ%40mail.gmail.com>
Precedence: bulk

--00000000000091a31a06264ef9c2
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks everyone for your valuable inputs.

On Wed, 6 Nov, 2024, 9:33=E2=80=AFpm Alvaro Herrera, <alvherre@alvh.no-ip.o=
rg>
wrote:

> On 2024-Nov-06, Wasim Devale wrote:
>
> > Hi All
> >
> > I have a table having bytea datatype. Anyone has worked on it how we ca=
n
> > 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.
>
> --
> =C3=81lvaro Herrera        Breisgau, Deutschland  =E2=80=94
> https://www.EnterpriseDB.com/
>

--00000000000091a31a06264ef9c2
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<p dir=3D"ltr">Thanks everyone for your valuable inputs.</p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed=
, 6 Nov, 2024, 9:33=E2=80=AFpm Alvaro Herrera, &lt;<a href=3D"mailto:alvher=
re@alvh.no-ip.org">alvherre@alvh.no-ip.org</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex">On 2024-Nov-06, Wasim Devale wrote:<br>
<br>
&gt; Hi All<br>
&gt; <br>
&gt; I have a table having bytea datatype. Anyone has worked on it how we c=
an<br>
&gt; see the content as the files are in .csv, .pdf, .bin and .docx format.=
<br>
<br>
In a pinch, you could turn the bytea column into an LO using the<br>
lo_from_bytea() function and use psql&#39;s \lo_export.=C2=A0 Quick and eas=
y, no<br>
need to write any code.<br>
<br>
-- <br>
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 Breisgau, Deutschland=C2=A0 =
=E2=80=94=C2=A0 <a href=3D"https://www.EnterpriseDB.com/" rel=3D"noreferrer=
 noreferrer" target=3D"_blank">https://www.EnterpriseDB.com/</a><br>
</blockquote></div>

--00000000000091a31a06264ef9c2--