You can beatify/uglify a SQL query with TablePlus.
This is incredibly helpful when you need to reformat the code before adding it the the application, or just want to remove some unwanted special characters such as unbreakable space.
- Open SQL Query Editor by clicking on the SQL button on the top left of the workspace, or use the shortcut keys Cmd + E.
- Enter your query into the editor.
- Hit Command + I to beautify the SQL.
- Hit Command + Shift + I to uglify the SQL.
You can also do it by clicking on the Beautify/Uglify button at the bottom of the query editor.
Need a good GUI tool for PostgreSQL? Check out TablePlus. It’s native, beautiful, and available for free.
Not on Mac? Download TablePlus for Windows.