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

From: Amul Sul <sulamul(at)gmail(dot)com>
To: mahendrakar s <mahendrakarforpg(at)gmail(dot)com>
Cc: pgsql-novice <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: Read rows from a table and process - Need pointers
Date: 2022-05-17 04:05:32
Message-ID: CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, May 16, 2022 at 11:57 PM mahendrakar s
<mahendrakarforpg(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2022-05-17 05:42:11 Re: Read rows from a table and process - Need pointers
Previous Message mahendrakar s 2022-05-16 18:27:13 Read rows from a table and process - Need pointers