RE: Extra brackets when viewing SQL - Mailing list pgsql-admin

From Blum, Kimber
Subject RE: Extra brackets when viewing SQL
Date
Msg-id DM6PR11MB3594E96A8970DFF7A669B5CD96CB0@DM6PR11MB3594.namprd11.prod.outlook.com
Whole thread Raw
In response to Extra brackets when viewing SQL  (Joe Tailleur <joe.tailleur@gmail.com>)
List pgsql-admin

I agree! That is a pain.

 

From: Joe Tailleur <joe.tailleur@gmail.com>
Sent: Thursday, December 10, 2020 8:49 AM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Extra brackets when viewing SQL

 

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.  Can I somehow disable this?  It's a real pain in the butt.

 

Joe.

 

 

pgsql-admin by date:

Previous
From: Joe Tailleur
Date:
Subject: Extra brackets when viewing SQL
Next
From: Ron
Date:
Subject: Re: Extra brackets when viewing SQL