Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n7egE-0006xL-Rw for pgsql-general@arkaria.postgresql.org; Wed, 12 Jan 2022 14:32:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n7egD-0006xv-OD for pgsql-general@arkaria.postgresql.org; Wed, 12 Jan 2022 14:32:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n7egD-0006xl-Ds for pgsql-general@lists.postgresql.org; Wed, 12 Jan 2022 14:32:49 +0000 Received: from mail-yb1-xb2f.google.com ([2607:f8b0:4864:20::b2f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n7egB-00009H-KC for pgsql-general@postgresql.org; Wed, 12 Jan 2022 14:32:49 +0000 Received: by mail-yb1-xb2f.google.com with SMTP id p187so7050335ybc.0 for ; Wed, 12 Jan 2022 06:32:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=cDFOc6D33jQwNXbf7WNrRHw4JPlQbm2tPcKJqEeJ2Ro=; b=FG5EOrZRNoJo5g5JFwzfuYSG40HiDxeQqBF0qDQ9cMKCkQPADk7+Bzy+1f74tRNV/h ANcO+C2vUjjRubSAisLzcVkXyk7EKAtBasHz2KrcH+NdJyJO/gswg+a54K1/QsuuiOqG az35NclvkD9NjDU2wlHjdWtvAR1R6UdE8PEJrTZsdtK66LxK/BcT7RzGxx6Mvg+0q85t 4FfmT7EZhkj7UKuW6G8DaadWviIBHEGjd1kE/GjFkDYDSo+poigN7r4SmdIFk8W4T1ni jHG5weA6qY0GuwiqGzQqmPJSstoMyhgsS5n+4mrBHT2oIX3IdN8ZZU1G/028HaUycj4E SaSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=cDFOc6D33jQwNXbf7WNrRHw4JPlQbm2tPcKJqEeJ2Ro=; b=zbdXts2aSOAat17eLOfDnR9erUXuHUQsMKDdyDpZAbXlIL/n2qbtjIdizdr3rHX/e2 RiSaD7E8wXUErPf7bq/JiilNCG7uUwxeXtpjz4rlXsWwO9nVJbbAX1gYTloHivb9NWTL JEruAsqlkdCKJHDRGWUNKcmFHEhGJav4OLcv8J4xy7IkERToe5vMoalB9JXc7Oqo6yII MRje8L4sP4EtI117V9PXQcSY0y2pGxoaYZl0R2tt99wL1vrI9GuJ3fw+/kuZ4saYoSke JUsnUNQ407OfRNXC/0/94iVHTfZXouoqBak1cDda7BXtaJgsQXeZa4BLG5Wz2pYNkUFx C6pQ== X-Gm-Message-State: AOAM5307yOZtH55Kmo1Sod+cGtqsxA4+Zqm8Y2pMdqs6NGM84JazqTVy pByoN82h+cXiJvpJQANnv2Ha+4auEGGLBGvSuMI= X-Google-Smtp-Source: ABdhPJxuS3xe0uuMScga/brhNCIGSVDwmDUKZqen3CQW4PFaKmUEjxgn8+ZYMM6oJkGDS4d/uAHfeZpi4v7H+CdUsBQ= X-Received: by 2002:a5b:ec2:: with SMTP id a2mr10560191ybs.211.1641997965902; Wed, 12 Jan 2022 06:32:45 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= Date: Wed, 12 Jan 2022 19:32:36 +0500 Message-ID: Subject: Re: How to read an external pdf file from postgres? To: Amine Tengilimoglu Cc: "pgsql-general@postgresql.org >> PG-General Mailing List" Content-Type: multipart/alternative; boundary="0000000000007ac8a505d56371ac" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007ac8a505d56371ac Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable What are you going to do with the data? If you want to analyze it in some way, I can't think of a better option with a Python function. Or do you just want to transfer them? There are options here too, but in this case I like Python better. -- Regards, Dmitry! =D1=81=D1=80, 12 =D1=8F=D0=BD=D0=B2. 2022 =D0=B3. =D0=B2 16:16, Amine Tengi= limoglu : > Hi; > > 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. > > Thanks. > --0000000000007ac8a505d56371ac Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
What are you going to do with the data?
If you want to = analyze it in some way, I can't think of a better option with a Python = function. Or do you just want to transfer them? There are options here too,= but in this case I like Python better.
--
Regards, Dmitry!


<= div class=3D"gmail_quote">
=D1=81=D1= =80, 12 =D1=8F=D0=BD=D0=B2. 2022 =D0=B3. =D0=B2 16:16, Amine Tengilimoglu &= lt;aminetengilimoglu@gmail.c= om>:
=C2=A0 Hi;

=C2=A0 =C2=A0 =C2=A0I want to re= ad an external pdf file from postgres. pdf file will exist=C2=A0on the disk= . postgres only know=C2=A0the=C2=A0disk 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?=C2=A0=C2=A0Or what is the best approach for this?=C2=A0I&#= 39;d appreciate it if anyone with experience could make suggestions.
<= div>
=C2=A0Thanks.
--0000000000007ac8a505d56371ac--