I would appreciate if DbVis supported psql commands or at least ignored them. I tried to make DbVis treat as comments, but while the syntax highlighting is good, the exection seems to fail.
Can you please post an example SQL? Have you tried enabling the new Allow SQL Dialects in Tool Properties under the General / SQL Commander / Statement Delimiters?
I tried the dialect option, but it did not work out.
create or replace view CROP_PLANT_DENORMALISED as
[Code: 0, SQL State: 42601] ERROR: syntax error at or near "\"
Position: 1 [Script position: 340 - 345]
By default DbVisualizer sends comments to the database when executing. When setting Single Line Identifier 2 to \ have you also set Strip Comments when Executing as indicated in the screenshot below?
Thanks for the hint. I forgot about that option. My comment workaround works now.