If you are using IntelliJ (Ultimate), it also have very good support for SQL (syntax highlighting, autocomplete, etc.) and is Postgresql flavor aware.

https://www.jetbrains.com/help/idea/database-tool-window.htm...