Re: libpq simple SELECT

2025-12-17 Thread Laurenz Albe
On Wed, 2025-12-17 at 13:07 -0800, Igor Korot wrote: > This is a comment: > > /* > * Our test case here involves using a cursor, for which we must be inside > * a transaction block.  We could do the whole thing with a single > * PQexec() of "select * from pg_database", but that's to

Re: libpq simple SELECT

2025-12-17 Thread Igor Korot
David,, On Wed, Dec 17, 2025 at 1:14 PM David G. Johnston wrote: > > On Wednesday, December 17, 2025, Igor Korot wrote: >> >> >> I hope now my question is clear. I want to know if using CURSR >> is a must. > > > No it is not. But there isn’t an example of doing so without a cursor > because it

Re: libpq simple SELECT

2025-12-17 Thread David G. Johnston
On Wednesday, December 17, 2025, Igor Korot wrote: > > I hope now my question is clear. I want to know if using CURSR > is a must. > No it is not. But there isn’t an example of doing so without a cursor because it is deemed trivial enough that a competent C writer can figure it out. In particu

Re: libpq simple SELECT

2025-12-17 Thread Igor Korot
Laurenz, On Wed, Dec 17, 2025 at 12:22 PM Laurenz Albe wrote: > > On Wed, 2025-12-17 at 09:42 -0800, Igor Korot wrote: > > On Tue, Dec 16, 2025 at 11:34 PM Laurenz Albe > > wrote: > > > On Tue, 2025-12-16 at 21:49 -0800, Igor Korot wrote: > > > > I just tried the following code: > > > > > > > >

Re: libpq simple SELECT

2025-12-17 Thread Laurenz Albe
On Wed, 2025-12-17 at 09:42 -0800, Igor Korot wrote: > On Tue, Dec 16, 2025 at 11:34 PM Laurenz Albe > wrote: > > On Tue, 2025-12-16 at 21:49 -0800, Igor Korot wrote: > > > I just tried the following code: > > > > > > [code] > > >      std::wstring query1 = L"SELECT t.table_catalog AS catalog, >

Re: libpq simple SELECT

2025-12-17 Thread Igor Korot
Lauren’s,, On Tue, Dec 16, 2025 at 11:34 PM Laurenz Albe wrote: > On Tue, 2025-12-16 at 21:49 -0800, Igor Korot wrote: > > I just tried the following code: > > > > [code] > > std::wstring query1 = L"SELECT t.table_catalog AS catalog, > > t.table_schema AS schema, t.table_name AS table, u.use

Re: libpq simple SELECT

2025-12-16 Thread Laurenz Albe
On Tue, 2025-12-16 at 21:49 -0800, Igor Korot wrote: > I just tried the following code: > > [code] > std::wstring query1 = L"SELECT t.table_catalog AS catalog, > t.table_schema AS schema, t.table_name AS table, u.usename AS owner, > c.oid AS table_id FROM information_schema.tables t, > pg_cata

libpq simple SELECT

2025-12-16 Thread Igor Korot
Hi, ALL, On the page https://www.postgresql.org/docs/current/libpq-example.html in the first program there is a following comment: [code] /* * Our test case here involves using a cursor, for which we must be inside * a transaction block. We could do the whole thing with a single *