Re: How to read an external pdf file from postgres?

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Amine Tengilimoglu <aminetengilimoglu(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to read an external pdf file from postgres?
Date: 2022-01-12 11:25:18
Message-ID: 08628ac8-0b69-391c-3387-60188a9b1882@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12.01.22 12:16, Amine Tengilimoglu wrote:
>      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.

You could write a function in PL/Perl or PL/Python to open and read the
file and process the PDF data, using some third-party module that surely
exists somewhere.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2022-01-12 11:57:45 postgres event trigger workaround
Previous Message Amine Tengilimoglu 2022-01-12 11:16:34 How to read an external pdf file from postgres?