Re: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such?
От | Aditya Toshniwal |
---|---|
Тема | Re: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such? |
Дата | |
Msg-id | CAM9w-_n-_EM7nvyEbTbD_7KU-KcDmOLWp09KNE-==+p4CJ1iXw@mail.gmail.com обсуждение исходный текст |
Ответ на | Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such? (Ni Ne <nineoften@hotmail.com>) |
Ответы |
Re: Possible to stop pgAdmin4 from re-formatting my SQL statements in Views and such?
|
Список | 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@hotmail.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.
- It will change spacing/indentation, and line-breaks. This is what I am hoping to stop.
- 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
"Don't Complain about Heat, Plant a TREE"
В списке pgadmin-support по дате отправления: