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.