Message-ID: <08628ac8-0b69-391c-3387-60188a9b1882@enterprisedb.com>
Date: Wed, 12 Jan 2022 12:25:18 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.4.1
Subject: Re: How to read an external pdf file from postgres?
Content-Language: en-US
To: Amine Tengilimoglu <aminetengilimoglu@gmail.com>,
 "pgsql-general@postgresql.org >> PG-General Mailing List"
 <pgsql-general@postgresql.org>
References: 
 <CADTdw-x=c_=OFyh3DoCkaygGAkChi36O=acZHQ2-F_DgQGJGpQ@mail.gmail.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: 
 <CADTdw-x=c_=OFyh3DoCkaygGAkChi36O=acZHQ2-F_DgQGJGpQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/08628ac8-0b69-391c-3387-60188a9b1882%40enterprisedb.com>
Precedence: bulk

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.