Re: Extra brackets when viewing SQL.

Hi,

This issue is already logged. Please refer:
https://redmine.postgresql.org/issues/6061

Thanks,
Khushboo

On Thu, Dec 10, 2020 at 11:54 PM Joe Tailleur <joe(dot)tailleur(at)gmail(dot)com>
wrote:

>
> Joe Tailleur <joe(dot)tailleur(at)gmail(dot)com>
> 8:47 AM (2 hours ago)
> to pgadmin-support
> Hi all,
>
> In version 4.27 when I viewed my SQL (sql tab when highlighting an item).
>
> For example:
> CREATE OR REPLACE VIEW asap.view_assignment
> AS
> SELECT pa.assign_id,
> pa.proj_id,
> pa.date_assigned,
> pa.time_assigned,
> au.user_name AS assigned_to,
> pa.assigned_level,
> pa.note,
> eb.user_name AS assigned_by
> FROM proj_assign pa
> JOIN asap_users au ON au.user_uid = pa.assigned_to_user
> LEFT JOIN asap_users eb ON eb.user_uid = pa.assigned_by_user;
>
>
> In version 4.28 (and 4.29)
> CREATE OR REPLACE VIEW asap.view_assignment
> AS
> SELECT pa.assign_id,
> pa.proj_id,
> pa.date_assigned,
> pa.time_assigned,
> au.user_name AS assigned_to,
> pa.assigned_level,
> pa.note,
> eb.user_name AS assigned_by
> FROM ((proj_assign pa
> JOIN asap_users au ON ((au.user_uid = pa.assigned_to_user)))
> LEFT JOIN asap_users eb ON ((eb.user_uid = pa.assigned_by_user)));
>
> I really don't like the extra brackets that are being placed around the
> FROM and JOINs, and they show up as well in CASE statements within SELECT
> and other sections as well. It gets really difficult when a complex
> statement might involve 10 joins; and brackets are all over the place.
> They are making my more complex queries difficult to read when I look at
> them in the SQL tab.
>
> Can I somehow disable this? It's a real pain in the butt. It was similar
> a few versions ago; and then was corrected; but now it's back.
>
>
> Joe.
>