public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Amul Sul <[email protected]>
Cc: 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 01:42:11 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com>
References: <CABkiuWppFhqCvOSXqXjZZdVMSRc+xMLvbXjQfwuvcQ5P4tozrA@mail.gmail.com>
	<CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com>

Amul Sul <[email protected]> writes:
> On Mon, May 16, 2022 at 11:57 PM mahendrakar s
> <[email protected]> wrote:
>> 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.

More fundamentally, why do you want to operate at such a low level
in the first place?  The SPI APIs are often more fit for purpose.

			regards, tom lane

view thread (3+ messages)

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], [email protected]
  Subject: Re: Read rows from a table and process - Need pointers
  In-Reply-To: <[email protected]>

* 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