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!

Reply via email to