From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amul Sul <sulamul@gmail.com>
cc: mahendrakar s <mahendrakarforpg@gmail.com>,
        pgsql-novice <pgsql-novice@lists.postgresql.org>
Subject: Re: Read rows from a table and process - Need pointers
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>
Comments: In-reply-to Amul Sul <sulamul@gmail.com>
	message dated "Tue, 17 May 2022 09:35:32 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1515616.1652766131.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 17 May 2022 01:42:11 -0400
Message-ID: <1515617.1652766131@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1515617.1652766131%40sss.pgh.pa.us>
Precedence: bulk

Amul Sul <sulamul@gmail.com> writes:
> On Mon, May 16, 2022 at 11:57 PM mahendrakar s
> <mahendrakarforpg@gmail.com> wrote:
>> I have a table test with two columns varchar and json. I need to open t=
est table and read the rows (string and json object) and process them insi=
de pg extension 'C' code.
>> How to do this?  There is table_open function in pg code but it require=
s 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