Postgres Pro
Downloads
Home   >   mailing lists

Re: Read rows from a table and process - Need pointers - Mailing list pgsql-novice

From Amul Sul
Subject Re: Read rows from a table and process - Need pointers
Date
Msg-id CAAJ_b97EEhJejL7fMbnsdL36_HqZRDZzjx1Vs+wt-fK4Y8whSA@mail.gmail.com
Whole thread Raw
In response to Read rows from a table and process - Need pointers  (mahendrakar s <mahendrakarforpg@gmail.com>)
Responses Re: Read rows from a table and process - Need pointers
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: mahendrakar s
Date:
Subject: Read rows from a table and process - Need pointers
Next
From: Tom Lane
Date:
Subject: Re: Read rows from a table and process - Need pointers