Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t8fjM-005Mr0-0H
	for pgsql-admin@arkaria.postgresql.org; Wed, 06 Nov 2024 13:05:51 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t8fjI-0062sn-Gh
	for pgsql-admin@arkaria.postgresql.org; Wed, 06 Nov 2024 13:05:49 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <wasimd60@gmail.com>)
	id 1t8fjI-0062sf-4x
	for pgsql-admin@lists.postgresql.org; Wed, 06 Nov 2024 13:05:48 +0000
Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <wasimd60@gmail.com>)
	id 1t8fjG-000TN2-6v
	for pgsql-admin@postgresql.org; Wed, 06 Nov 2024 13:05:47 +0000
Received: by mail-ej1-x62e.google.com with SMTP id
 a640c23a62f3a-a99e3b3a411so154062166b.0
        for <pgsql-admin@postgresql.org>;
 Wed, 06 Nov 2024 05:05:46 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1730898344; x=1731503144;
 darn=postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=rddxKaunSUe4dCVfUuf1aIMhccOOJ/aMXzQzBKe/TY4=;
        b=MzS2CK4jLOm3qnzUHMbKjvDx9nHEIaaCCRotcrj5lONPaLNBDdQjpeg+OS1/53iHpC
         aPaFdxTtD8hWYvk29pSl6NXHDmpGtNZoDWBK9CXT0usACo4fCqrn3h/Gnp3rSnnvRv1b
         YhGiMd9Rsytpxwpq0GxJlEx4scq2I5RiJSaGeDS+Jl07TtTKoTK04wOQCBDAjX5Ca39X
         fgxrsMv5rifiTIZTtNc5S4pJlv1RcD6f88Ct2lQKSEkmMSvhk8ukLtvkTn57eRz3jN91
         yXOU4p8xGy5o6xShj9pp5wSbs6Tx8c78l7OES4xY4GHdlkKFlYzxXbcr9uA4rnicDYzn
         WiOw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1730898344; x=1731503144;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=rddxKaunSUe4dCVfUuf1aIMhccOOJ/aMXzQzBKe/TY4=;
        b=eIbFh0ZkjzdjwCfLi6L02ys14ZteoxVTwwijPp810oSwo+FRU039Px3ZSpWKZO89vx
         SdCTaGa0TMjETvKm4p1Qskxs/Vf2k3v6G4xWN21w8xymcCoACAWCbHlrdpqDL2dhZ1XS
         UVU1m1kkm9hT8SPjDnHoVk2X8iHf0RuDPbJ6PTj/1l1/XIk/MM+0qSp/pbpvSiwhd7Vh
         3gCTbFWEd9qq66Fmoskuyzd7MfLk/j5cOV+dNAFU7jTxyK/SdyxQuB8GdC97+HACAo1L
         oYZ2a4lBspYb+VEe8vyhnHTvyO3ASkE+Khq6rUp8/JTAGyHW4myM+Gp8tLws6iJCIBQG
         0MjQ==
X-Gm-Message-State: AOJu0YzY86ZsB94ugAKTuj6UUrQbV+9w1qcvJtBThoHYwiVhvRClrXWb
	avQ5Nko2Yb16LqbON6G2YsXz37M3xEyEtD3pZ+Wqu/Aro+KAtb6Lod4CQjfRnyDxVCbcUOAcGYV
	nHlSd/SqA91rmstmhQA42+vLw0qqbBg==
X-Google-Smtp-Source: 
 AGHT+IEz0/swHnJyMcYMI/CO0PAfGINjhT30zscQgHgsBrqwWlAlL6ES9KarCq/BEjd/jpG6Q/6jdfs8iThSGN2hvyk=
X-Received: by 2002:a17:907:97ca:b0:a9a:1ef0:837b with SMTP id
 a640c23a62f3a-a9ec66049b4mr254085766b.10.1730898343407; Wed, 06 Nov 2024
 05:05:43 -0800 (PST)
MIME-Version: 1.0
From: Wasim Devale <wasimd60@gmail.com>
Date: Wed, 6 Nov 2024 18:35:30 +0530
Message-ID: 
 <CAB5fag593g9wK+hDdWDqRDUnd-N1XLAFNaGKv37F95LngkvdgQ@mail.gmail.com>
Subject: Bytea datatype content to view
To: pgsql-admin <pgsql-admin@postgresql.org>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e6bb3006263e2c6c"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAB5fag593g9wK%2BhDdWDqRDUnd-N1XLAFNaGKv37F95LngkvdgQ%40mail.gmail.com>
Precedence: bulk

--000000000000e6bb3006263e2c6c
Content-Type: text/plain; charset="UTF-8"

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

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

<div dir=3D"auto">Hi All<div dir=3D"auto"><br></div><div dir=3D"auto">I hav=
e 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.</div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">Can anyone help=C2=A0with this? Any=
 SQL script or python script to view the content?</div><div dir=3D"auto"><b=
r></div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Wasim</div></div>

--000000000000e6bb3006263e2c6c--