public inbox for [email protected]  
help / color / mirror / Atom feed
From: 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