Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such?

From: Ni Ne <nineoften(at)hotmail(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such?
Date: 2022-02-18 18:11:07
Message-ID: CY4PR06MB2486BCFD9738E5EE74D7F4B3B5379@CY4PR06MB2486.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I have a syntax format for SQL that I prefer, so when I craft new Views or what-not I write them out a certain way.

When I save that SQL into a View, pgAdmin4 will re-format it. If I later need to debug that View, it adds some complexity for me because first I have to re-format the layout in a text file in the format I understand best.

Is it possible to turn this off, so that pgAdmin4 saves exactly what I enter?

I guess there are two parts to what pgAdmin is doing.

1. It will change spacing/indentation, and line-breaks. This is what I am hoping to stop.
2. It does some optimization apparently. It will adjust statements to be more efficient I guess, as well as do things like change "SELECT *" into "SELECT c1,c2,c3" or add explicit type-casting. This stuff is fine for me.

Thanks!

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message A Shreyas 2022-02-21 05:36:49 RE: Request from THALES Global Services to JDBC POSTGRESQL
Previous Message Christophe Pettus 2022-02-16 16:53:46 Re: Request from THALES Global Services to JDBC POSTGRESQL