From: Florents Tselai <florents.tselai@gmail.com>
Message-Id: <D2452509-620C-416D-AA9B-F606E622E826@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_6D8AF91C-7786-419C-B975-E90B0AF4BD1E"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\))
Subject: Re: How to read an external pdf file from postgres?
Date: Mon, 10 Feb 2025 15:01:48 +0200
In-Reply-To: <CAB8KJ=hBm3QwtOq9_gM+=a-2Kx2crz3yh+vxsckEEE+EdsjdwQ@mail.gmail.com>
Cc: Amine Tengilimoglu <aminetengilimoglu@gmail.com>,
 "pgsql-general@postgresql.org >> PG-General Mailing List" <pgsql-general@postgresql.org>
To: Ian Lawrence Barwick <barwick@gmail.com>
References: <CADTdw-x=c_=OFyh3DoCkaygGAkChi36O=acZHQ2-F_DgQGJGpQ@mail.gmail.com>
 <CAB8KJ=hBm3QwtOq9_gM+=a-2Kx2crz3yh+vxsckEEE+EdsjdwQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/D2452509-620C-416D-AA9B-F606E622E826%40gmail.com>
Precedence: bulk


--Apple-Mail=_6D8AF91C-7786-419C-B975-E90B0AF4BD1E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> On 12 Jan 2022, at 4:35=E2=80=AFPM, Ian Lawrence Barwick =
<barwick@gmail.com> wrote:
>=20
> 2022=E5=B9=B41=E6=9C=8812=E6=97=A5(=E6=B0=B4) 20:16 Amine Tengilimoglu =
<aminetengilimoglu@gmail.com>:
>>=20
>>  Hi;
>>=20
>>     I want to read an external pdf file from postgres. pdf file will =
exist on the disk. postgres only know the disk full path as metadata. Is =
there any software or extension that can be used for this? Or do we have =
to develop software for it?  Or what is the best approach for this? I'd =
appreciate it if anyone with experience could make suggestions.
>=20
> By "read" do you mean "open the file and meaningful extract data from =
it"? If
> so, speaking from prior experience, don't. And if you really have to, =
make sure
> the source PDF is guaranteed to be in a well-defined, predictable =
format
> enforceable by contract law and/or people with sharp pointy sticks. I =
have
> successfully suppressed the memories of whatever it is I once had to =
do with
> reading data from PDFs, but though the data was eventually imported =
into
> PostgreSQL, there was a lot of mangling probably involving a Perl =
module (other
> languages are probably available) before it got anywhere near the =
database.
>=20
>=20
> Reagrds
>=20
> Ian Barwick
>=20
> --=20
> EnterpriseDB: https://www.enterprisedb.com
>=20
>=20

https://github.com/Florents-Tselai/pgpdf=

--Apple-Mail=_6D8AF91C-7786-419C-B975-E90B0AF4BD1E
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;"><br =
id=3D"lineBreakAtBeginningOfMessage"><div><br><blockquote =
type=3D"cite"><div>On 12 Jan 2022, at 4:35=E2=80=AFPM, Ian Lawrence =
Barwick &lt;barwick@gmail.com&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div><div>2022=E5=B9=B41=E6=9C=8812=E6=
=97=A5(=E6=B0=B4) 20:16 Amine Tengilimoglu =
&lt;aminetengilimoglu@gmail.com&gt;:<br><blockquote type=3D"cite"><br> =
&nbsp;Hi;<br><br> &nbsp;&nbsp;&nbsp;&nbsp;I want to read an external pdf =
file from postgres. pdf file will exist on the disk. postgres only know =
the disk full path as metadata. Is there any software or extension that =
can be used for this? Or do we have to develop software for it? &nbsp;Or =
what is the best approach for this? I'd appreciate it if anyone with =
experience could make suggestions.<br></blockquote><br>By "read" do you =
mean "open the file and meaningful extract data from it"? If<br>so, =
speaking from prior experience, don't. And if you really have to, make =
sure<br>the source PDF is guaranteed to be in a well-defined, =
predictable format<br>enforceable by contract law and/or people with =
sharp pointy sticks. I have<br>successfully suppressed the memories of =
whatever it is I once had to do with<br>reading data from PDFs, but =
though the data was eventually imported into<br>PostgreSQL, there was a =
lot of mangling probably involving a Perl module (other<br>languages are =
probably available) before it got anywhere near the =
database.<br><br><br>Reagrds<br><br>Ian Barwick<br><br>-- =
<br>EnterpriseDB: =
https://www.enterprisedb.com<br><br><br></div></div></blockquote></div><br=
><div><a =
href=3D"https://github.com/Florents-Tselai/pgpdf">https://github.com/Flore=
nts-Tselai/pgpdf</a></div></body></html>=

--Apple-Mail=_6D8AF91C-7786-419C-B975-E90B0AF4BD1E--