From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | Ni Ne <nineoften(at)hotmail(dot)com> |
Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such? |
Date: | 2022-02-21 06:20:53 |
Message-ID: | CAM9w-_n-_EM7nvyEbTbD_7KU-KcDmOLWp09KNE-==+p4CJ1iXw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi Ni Ne,
pgAdmin reverse engineers the SQL based on the available catalog and schema
information. I don't think PostgreSQL saves the exact formatting when
creating objects (except function/procedure body).
On Fri, Feb 18, 2022 at 11:41 PM Ni Ne <nineoften(at)hotmail(dot)com> wrote:
> 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!
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2022-02-21 06:53:55 | Re: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such? |
Previous Message | A Shreyas | 2022-02-21 05:36:49 | RE: Request from THALES Global Services to JDBC POSTGRESQL |