On Fri, Jul 22, 2022 at 07:05:31AM -0600, Rob Sargent wrote:
>
>
> > On Jul 22, 2022, at 6:31 AM, H <[email protected]> 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
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 <[email protected]> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
