How to read an external pdf file from postgres?

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 appr

Re: ERROR: unrecognized node type

On 9/29/21 8:37 PM, Tom Lane wrote: > Adrian Klaver writes: >> Unless folks are using plain text only email readers. That is why >> screenshots are generally a bad idea for textual information. For the >> record the Postgres version is 12.8. > > Hmm, if it's v12 then NodeTag 223 is T_List, which i

Re: ERROR: unrecognized node type

I thought that the server version can be guess from the screenshot . I already update the latest minor pg version and it didn't work :) Thank you Tom. Tom Lane , 29 Eyl 2021 Çar, 20:16 tarihinde şunu yazdı: > Amine Tengilimoglu writes: > > I am getting the "ERROR: unr

ERROR: unrecognized node type

Hi; I am getting the "ERROR: unrecognized node type: 223" when I execute \d combinations in psql and even when getting backup with pg_dump... probably the same error will occur with other commands. What is causing this issue, any idea? How to fix it? [image: image.png]

what is the best way to access cold data on another server?

Hello everyone; In addition to the actively used data, there are other data that are very little accessed. I want to separate the less used data to save space and reduce maintenance operations. I want to use a separate postgres instance for this. Now the question is; How do I link these two in

Re: How to get column and identifier names in UPPERCASE in postgres?

:Thank you. Pavel Stehule , 20 Kas 2019 Çar, 16:12 tarihinde şunu yazdı: > Hi > > st 20. 11. 2019 v 14:11 odesílatel Amine Tengilimoglu < > aminetengilimo...@gmail.com> napsal: > >> Hi all; >> >> I want to get the column and other identifier na

How to get column and identifier names in UPPERCASE in postgres?

Hi all; I want to get the column and other identifier names in UPPERCASE form rather than a lowercase one without changing application code like qouting the identifiers. Do you know any settings function or extention for this purpose? thank you.

Upgrade Standby

Hi; What is the best way for upgrading standby server on postgresql? I dont want to use --link option for master upgrading that is why it seems just one way for achive this..this way is setup sr again... thanks in advence...