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.taill...@gmail.com> wrote: > > Joe Tailleur <joe.taill...@gmail.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. >
