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.
SQL formatter or prettyfier?
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: SQL formatter or prettyfier?
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.
Checkout vertica.tips for more Vertica resources.
Re: SQL formatter or prettyfier?
Thanks for your reply.
In what ways does "Instant SQL Formatter" fall short?
In what ways does "Instant SQL Formatter" fall short?
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: SQL formatter or prettyfier?
It does not support some of the Vertica specific functions and will throw an error in the output.
Checkout vertica.tips for more Vertica resources.
-
- Newbie
- Posts: 1
- Joined: Tue Aug 14, 2018 9:53 am
Re: SQL formatter or prettyfier?
Here is one more great service for beautifying SQL code - Online SQL Formatter http://sql-format.com/