Re: Paging through table one row at a ttime

2022-07-22 Thread H
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

Re: Paging through table one row at a ttime

2022-07-22 Thread Rob Sargent
> On Jul 22, 2022, at 6:31 AM, H 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 sin

Re: Paging through table one row at a ttime

2022-07-22 Thread Bruce Momjian
On Fri, Jul 22, 2022 at 07:05:31AM -0600, Rob Sargent wrote: > > > > On Jul 22, 2022, at 6:31 AM, H 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 ot

Re: Paging through table one row at a ttime

2022-07-22 Thread H
On 07/22/2022 03:14 PM, Bruce Momjian wrote: > On Fri, Jul 22, 2022 at 07:05:31AM -0600, Rob Sargent wrote: >> >>> On Jul 22, 2022, at 6:31 AM, H 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 on

Re: Paging through table one row at a ttime

2022-07-22 Thread Bruce Momjian
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

How does postgres sort large strings?

2022-07-22 Thread Sergey Burladyan
Hi! I thought that the sorting values are stored entirely in work_mem, but in fact it works somehow differently. Can anyone suggest how this works? For example, I created this 512MB incompressible file and test table: tr -dcs '[:print:]' '[:print:]' < /dev/urandom | tr -d '"'\' | dd bs=1K coun

20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-22 Thread Techsupport
Hi Team, We are using PostgreSQL 12.3, It is running under windows In that server there is nearly 8 databases are running. I have changed the data directory from one drive to another drive. At the time of change the data directory, have stopped the PostgreSQL instance and Copy the co

Re: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-22 Thread Adrian Klaver
On 7/22/22 8:20 AM, Techsupport wrote: *Hi Team,* We are using PostgreSQL 12.3, It is running under windows In that server there is nearly 8 databases are running. I have changed the data directory from one drive to another drive. At the time of change the data directory, have stopped the P

Re: How does postgres sort large strings?

2022-07-22 Thread Francisco Olarte
On Fri, 22 Jul 2022 at 16:46, Sergey Burladyan wrote: > I thought that the sorting values are stored entirely in work_mem, but in > fact it works somehow differently. > Can anyone suggest how this works? In the classic go by chunks way? To sort values you need to compare them, to compare string

RE: 20220722-pg_dump: error: invalid number of parents 0 for table

2022-07-22 Thread Techsupport
: Techsupport; pgsql-general@lists.postgresql.org Subject: Re: 20220722-pg_dump: error: invalid number of parents 0 for table On 7/22/22 8:20 AM, Techsupport wrote: > *Hi Team,* > > We are using PostgreSQL 12.3, It is running under windows > > In that server there is nearly 8 databa