MIME-Version: 1.0
References: 
 <CADTdw-x=c_=OFyh3DoCkaygGAkChi36O=acZHQ2-F_DgQGJGpQ@mail.gmail.com>
In-Reply-To: 
 <CADTdw-x=c_=OFyh3DoCkaygGAkChi36O=acZHQ2-F_DgQGJGpQ@mail.gmail.com>
From: Ian Lawrence Barwick <barwick@gmail.com>
Date: Wed, 12 Jan 2022 23:35:16 +0900
Message-ID: 
 <CAB8KJ=hBm3QwtOq9_gM+=a-2Kx2crz3yh+vxsckEEE+EdsjdwQ@mail.gmail.com>
Subject: Re: How to read an external pdf file from postgres?
To: Amine Tengilimoglu <aminetengilimoglu@gmail.com>
Cc: "pgsql-general@postgresql.org >> PG-General Mailing List"
 <pgsql-general@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAB8KJ%3DhBm3QwtOq9_gM%2B%3Da-2Kx2crz3yh%2BvxsckEEE%2BEdsjdwQ%40mail.gmail.com>
Precedence: bulk

2022=E5=B9=B41=E6=9C=8812=E6=97=A5(=E6=B0=B4) 20:16 Amine Tengilimoglu <ami=
netengilimoglu@gmail.com>:
>
>   Hi;
>
>      I want to read an external pdf file from postgres. pdf file will exi=
st 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 deve=
lop software for it?  Or what is the best approach for this? I'd appreciate=
 it if anyone with experience could make suggestions.

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 wit=
h
reading data from PDFs, but though the data was eventually imported into
PostgreSQL, there was a lot of mangling probably involving a Perl module (o=
ther
languages are probably available) before it got anywhere near the database.


Reagrds

Ian Barwick

--=20
EnterpriseDB: https://www.enterprisedb.com