Thread: PgAdmin4 and tabs
It looks as if the display of function code in PgAdmin4 is not handling indentation properly, possibly due to TABS in the SQL.
Code that looks like
if .....
then
<TAB> if ....
<TAB> then
<TAB><TAB> ...
<TAB>end if;
end if;
gets displayed as
if ...
then
if ...
then
... <<-- this line is not indented properly
end if;
end if;
Is there a setting/preference for how to render TABS in the SQL display?
Hello,
On Fri, 20 Sep 2019, 20:41 Michael Shapiro, <mshapiro51@gmail.com> wrote:
It looks as if the display of function code in PgAdmin4 is not handling indentation properly, possibly due to TABS in the SQL.Code that looks likeif .....then<TAB> if ....<TAB> then<TAB><TAB> ...<TAB>end if;end if;gets displayed asif ...thenif ...then... <<-- this line is not indented properlyend if;end if;Is there a setting/preference for how to render TABS in the SQL display?
Yes, Please refer https://www.pgadmin.org/docs/pgadmin4/4.13/preferences.html#the-query-tool-node
Go to Editor section, and change Tab size and Use spaces options as per your needs.
Thanks! That fixed it
On Fri, Sep 20, 2019 at 9:31 PM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hello,On Fri, 20 Sep 2019, 20:41 Michael Shapiro, <mshapiro51@gmail.com> wrote:It looks as if the display of function code in PgAdmin4 is not handling indentation properly, possibly due to TABS in the SQL.Code that looks likeif .....then<TAB> if ....<TAB> then<TAB><TAB> ...<TAB>end if;end if;gets displayed asif ...thenif ...then... <<-- this line is not indented properlyend if;end if;Is there a setting/preference for how to render TABS in the SQL display?Yes, Please refer https://www.pgadmin.org/docs/pgadmin4/4.13/preferences.html#the-query-tool-nodeGo to Editor section, and change Tab size and Use spaces options as per your needs.