On Fri, Jul 22, 2022 at 07:05:31AM -0600, Rob Sargent wrote:
>
>
> > On Jul 22, 2022, at 6:31 AM, H <agents@meddatainc.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,
possiblyusing pspg (or other tool) allowing me to move in either direction in the table one single row at a time.
Ideallyonly the columns in the selected row should be visible, even better if there would be one column of that row per
rowin 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
backand forth row by row all that often. Have you found the LIMIT and OFFSET features of SELECT statement? After that
yourin application space and not this forum perhaps
Yeah, I was confused by the question. I originally thought you were
asking about pagination, and I have several blog entries about that:
https://momjian.us/main/blogs/pgblog/2020.html#August_17_2020
but it then sounded like you were looking for a terminal-level API,
which kind of sounded like pspg, which you are using, but something much
more sophisticated.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson