Обсуждение: Read rows from a table and process - Need pointers

Поиск
Список
Период
Сортировка

Read rows from a table and process - Need pointers

От
mahendrakar s
Дата:
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.

Re: Read rows from a table and process - Need pointers

От
Amul Sul
Дата:
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

Re: Read rows from a table and process - Need pointers

От
Tom Lane
Дата:
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