public inbox for [email protected]
help / color / mirror / Atom feedFrom: Amul Sul <[email protected]>
To: mahendrakar s <[email protected]>
Cc: pgsql-novice <[email protected]>
Subject: Re: Read rows from a table and process - Need pointers
Date: Tue, 17 May 2022 09:35:32 +0530
Message-ID: <CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com> (raw)
In-Reply-To: <CABkiuWppFhqCvOSXqXjZZdVMSRc+xMLvbXjQfwuvcQ5P4tozrA@mail.gmail.com>
References: <CABkiuWppFhqCvOSXqXjZZdVMSRc+xMLvbXjQfwuvcQ5P4tozrA@mail.gmail.com>
On Mon, May 16, 2022 at 11:57 PM mahendrakar s
<[email protected]> wrote:
>
> Hi,
>
> I have a table test with two columns varchar and json. I need to open test table and read the rows (string and json object) and process them inside pg extension 'C' code.
> How to do this? There is table_open function in pg code but it requires OID as input parameter.
>
See if table_openrv() works for you.
Regards,
Amul
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Read rows from a table and process - Need pointers
In-Reply-To: <CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox