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.
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.