Thread: Read rows from a table and process - Need pointers
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.
Thanks,
Mahendrakar.
On Mon, May 16, 2022 at 11:57 PM mahendrakar s <mahendrakarforpg@gmail.com> 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
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 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