Page 1 of 1
SQL formatter or prettyfier?
Posted: Tue Jul 15, 2014 1:48 pm
by dbmsuser7
Anyone know of a program which will take SQL code and format it nicely, which works with SQL written for Vertica?
I imagine there are some generic formatters but I'm not sure whether they'd leave the code intact.
Re: SQL formatter or prettyfier?
Posted: Tue Jul 15, 2014 3:53 pm
by NorbertKrupa
I have yet to come across a good one. The one I generally use is
Instant SQL Formatter with the MySQL or Generic database selected.
Re: SQL formatter or prettyfier?
Posted: Thu Jul 17, 2014 1:47 pm
by dbmsuser7
Thanks for your reply.
In what ways does "Instant SQL Formatter" fall short?
Re: SQL formatter or prettyfier?
Posted: Thu Jul 17, 2014 2:15 pm
by NorbertKrupa
It does not support some of the Vertica specific functions and will throw an error in the output.
Re: SQL formatter or prettyfier?
Posted: Tue Aug 14, 2018 9:56 am
by fomenkovoleg
Here is one more great service for beautifying SQL code - Online SQL Formatter
http://sql-format.com/