MIME-Version: 1.0
References: 
 <CAB5fag593g9wK+hDdWDqRDUnd-N1XLAFNaGKv37F95LngkvdgQ@mail.gmail.com>
In-Reply-To: 
 <CAB5fag593g9wK+hDdWDqRDUnd-N1XLAFNaGKv37F95LngkvdgQ@mail.gmail.com>
From: Steve Cooper <sdmagic@gmail.com>
Date: Wed, 6 Nov 2024 06:09:09 -0800
Message-ID: 
 <CAKbF40=P0h+H6_1vGhzGWxA6gX-sKkgTRfL1W8NsQ+=gAa7iqg@mail.gmail.com>
Subject: Re: Bytea datatype content to view
To: Wasim Devale <wasimd60@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005b003e06263f10f2"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKbF40%3DP0h%2BH6_1vGhzGWxA6gX-sKkgTRfL1W8NsQ%2B%3DgAa7iqg%40mail.gmail.com>
Precedence: bulk

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

A PostgreSQL bytea type is the hexadecimal representation of the ASCII
codes for a character string.

So, the string 'hex' translates to \x686578 in a bytea field.
\x68 =3D decimal 104 =3D 'h'; \x65 =3D decimal 101 =3D 'e'; \x78 =3D decima=
l 120 =3D 'x'

Here's a short Python function to translate hex ascii to a character string=
:

def hexToStr(hexString: str) -> str:
    # Convert hex string to bytes
    bytesObject: bytes =3D bytes.fromhex(hexString)
    # Decode bytes to string
    asciiString: str =3D bytesObject.decode("ASCII")
    return asciiString

if __name__ =3D=3D "__main__":
  hex_string =3D "686578"  # hexadecimal representation of the ASCII codes
for the string 'hex'
  print(hexToStr(hex_string))

# output: hex

Rewrite the above "__main__" part to open a database, select whatever, loop
through the results, translate the field(s) in question, and perform
whatever output you like.


On Wed, Nov 6, 2024 at 5:05=E2=80=AFAM Wasim Devale <wasimd60@gmail.com> wr=
ote:

> 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.
>
> Can anyone help with this? Any SQL script or python script to view the
> content?
>
> Thanks,
> Wasim
>

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

<div dir=3D"ltr"><div dir=3D"ltr">A PostgreSQL bytea type is the hexadecima=
l representation of the ASCII codes for a character string.<div><br></div><=
div>So, the string &#39;hex&#39; translates to=C2=A0\x686578 in a bytea fie=
ld.</div><div>\x68 =3D decimal 104 =3D &#39;h&#39;; \x65 =3D decimal 101 =
=3D &#39;e&#39;; \x78 =3D decimal 120 =3D &#39;x&#39;</div><div><br></div><=
div>Here&#39;s a short Python function to translate hex ascii to a characte=
r string:</div><div><br></div><div>def hexToStr(hexString: str) -&gt; str:<=
br>=C2=A0 =C2=A0 # Convert hex string to bytes<br>=C2=A0 =C2=A0 bytesObject=
: bytes =3D bytes.fromhex(hexString)<br>=C2=A0 =C2=A0 # Decode bytes to str=
ing<br>=C2=A0 =C2=A0 asciiString: str =3D bytesObject.decode(&quot;ASCII&qu=
ot;)<br>=C2=A0 =C2=A0 return asciiString<br><br>if __name__ =3D=3D &quot;__=
main__&quot;:<br>=C2=A0 hex_string =3D &quot;686578&quot;=C2=A0 # hexadecim=
al=C2=A0representation of the ASCII codes for the string &#39;hex&#39;<br>=
=C2=A0 print(hexToStr(hex_string))<br>=C2=A0 =C2=A0 =C2=A0 <br># output: he=
x</div><div><br></div><div>Rewrite the above &quot;__main__&quot; part to o=
pen a database, select whatever, loop through the results, translate the fi=
eld(s) in question, and perform whatever output you like.</div><div><br></d=
iv><div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cla=
ss=3D"gmail_attr">On Wed, Nov 6, 2024 at 5:05=E2=80=AFAM Wasim Devale &lt;<=
a href=3D"mailto:wasimd60@gmail.com">wasimd60@gmail.com</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi=
 All<div dir=3D"auto"><br></div><div dir=3D"auto">I have a table having byt=
ea datatype. Anyone has worked on it how we can see the content as the file=
s are in .csv, .pdf, .bin and .docx format.</div><div dir=3D"auto"><br></di=
v><div dir=3D"auto">Can anyone help=C2=A0with this? Any SQL script or pytho=
n script to view the content?</div><div dir=3D"auto"><br></div><div dir=3D"=
auto">Thanks,</div><div dir=3D"auto">Wasim</div></div>
</blockquote></div></div>

--0000000000005b003e06263f10f2--