SQL Formatter Issue /w Windowed Functions

From: <dulanic(at)gmail(dot)com>
To: <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: SQL Formatter Issue /w Windowed Functions
Date: 2021-06-03 12:38:34
Message-ID: 007101d75875$5e67d540$1b377fc0$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have been using the SQL formatter recently in PG admin and found an issue
/w windowed functions and the order by clause for the windows client. I
don’t see any setting to correct. Any ideas how to fix? As you can see, the
alignment /w the windows PGAdmin formatter is horrible.

This seems to effect PGAdmin in windows, as PGAdmin in docker formats
properly.

Look if I use PGAdmin 5.4 in Windows to format: *Incorrect

pgAdmin4-incorrect.png (2020×1120) (dulanic.com)
<https://dulanic.com/img/pgAdmin4-incorrect.png>

Look if I use VS Code to format: *Correct

VSCode-Correct.png (1307×849) (dulanic.com)
<https://dulanic.com/img/VSCode-Correct.png>

PGAdmin 5.3 Docker: *Correct

pgadmin-docker.png (1153×233) (dulanic.com)
<https://dulanic.com/img/pgadmin-docker.png>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Trung Do 2021-06-03 14:39:23 Open pgAdmin in browser
Previous Message Akshay Deore 2021-06-01 11:18:44 Re: Fatal error starting PgAdmin 4