| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Amul Sul <sulamul(at)gmail(dot)com> |
| Cc: | mahendrakar s <mahendrakarforpg(at)gmail(dot)com>, 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 05:42:11 |
| Message-ID: | 1515617.1652766131@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Amul Sul <sulamul(at)gmail(dot)com> writes:
> On Mon, May 16, 2022 at 11:57 PM mahendrakar s
> <mahendrakarforpg(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mahendrakar s | 2022-05-19 16:53:19 | Comparing two URL strings |
| Previous Message | Amul Sul | 2022-05-17 04:05:32 | Re: Read rows from a table and process - Need pointers |