Re: Paging through table one row at a ttime

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: H <agents(at)meddatainc(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Paging through table one row at a ttime
Date: 2022-07-22 13:05:31
Message-ID: DE7C226B-B472-447E-A9AA-232CAEE22EFE@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jul 22, 2022, at 6:31 AM, H <agents(at)meddatainc(dot)com> wrote:
>
> On 07/20/2022 03:09 PM, H wrote:
>> I am running postgres 13 under CentOS 7. I have a need to be able to page through a table one row at a time, possibly using pspg (or other tool) allowing me to move in either direction in the table one single row at a time. Ideally only the columns in the selected row should be visible, even better if there would be one column of that row per row in the terminal window but that would probably be wishing for too much.
>>
>> Is there any configuration of pspg that would allow me to do the above?
>>
>>
>>
> I have not seen any replies to my question above - is this perhaps not possible to do?
>
>
I didn’t follow the “even better”. Aside from that most of us are simple sql users and data managers - we don’t go back and forth row by row all that often. Have you found the LIMIT and OFFSET features of SELECT statement? After that your in application space and not this forum perhaps
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2022-07-22 13:14:38 Re: Paging through table one row at a ttime
Previous Message H 2022-07-22 12:28:21 Re: Paging through table one row at a ttime