Re: Rows (estimated) - how to change displayed number format

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
To: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Rows (estimated) - how to change displayed number format
Date: 2017-10-30 12:32:27
Message-ID: CAPB4dVjwyzV8dZFKOqhvAi0fY1a_9ZiO9Gpp4JvKGejOfCHM1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

See attached screenshots. In pgAdmin3 the number format would stay in the
"general" format no matter how large, in pgAdmin4 larger record numbers
show in exponential format, (BTW, the most user-friendly format is a
general format with thousand separators)

Note also that I cannot see any way to COUNT records in pgAdmin4 (and fill
in that field in the properties), obviously beyond writing a tiny query for
it. In pgAdmin3 you would right-click on any table and select "count".

Regards
Calle

On 30 October 2017 at 13:10, Murtuza Zabuawala <
murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:

>
> On Sat, Oct 28, 2017 at 5:24 AM, Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
> wrote:
>
>> Hi,
>>
>> I recently moved from pgAdmin III to 4.
>>
>> In pgAdmin III, the numbers for Rows (estimated) were in general format,
>> whereas in pgAdmin 4 they are in shown as exponential numbers.
>>
> Could you provide us a screenshot of affected area
> ​as well as from
> pgAdmin3(expected output)?
>
>>
>> How can I change this to a general number format, which I prefer?
>>
>> Regards
>> Calle, Cape Town
>>
>>
>>
>

--

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle(dot)hedberg(at)gmail(dot)com

Skype: calle_hedberg

*******************************************

Attachment Content-Type Size
pgAdmin3_tableProperties.PNG image/png 86.5 KB
pgAdmin4_tableProperties.PNG image/png 168.5 KB

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Murtuza Zabuawala 2017-10-30 12:43:14 Re: Rows (estimated) - how to change displayed number format
Previous Message Murtuza Zabuawala 2017-10-30 11:14:54 Re: pgadmin4 hangs when trying to input date