Re: Paging through table one row at a ttime

From: Bruce Momjian <bruce(at)momjian(dot)us>
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 14:39:59
Message-ID: Ytq2v0ZWVk2I7ckD@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 22, 2022 at 04:33:14PM +0200, H wrote:
> Let me flesh out my need a little bit more. I have a need for a
> quick-and-dirty solution to paging through a postgresql table. pspg
> almost fits that need but could be even better. Using pspg I can
> either: (1) view one table row in each pspg terminal window row using
> the pspg flag to shorten columns, or (2) list as much of the table row
> in the pspg terminal window as fits. Depending on the size of the row,
> this could mean less than one table row or more than one table row.
>
> To make it easier to view individual table rows in eg. pspg I would
> like to view exactly one table row, not more, and ideally each column
> of that table row would use individual pspg terminal rows.
>
> I hope that makes it clearer. Hoping this might be possible, either
> using pspg or other similar software. I am not writing any application
> code.

I would ask the pspg author on something that specific.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Burladyan 2022-07-22 14:46:37 How does postgres sort large strings?
Previous Message H 2022-07-22 14:33:14 Re: Paging through table one row at a ttime