The following statement works if I paste it into the SQL box, but it fails when uploaded in a script file.
select 'te--st' as example;
The error is:
test_comment.sql:1: ERROR: unterminated quoted string at or near "'te"
LINE 1: select 'te
It is parsing out the comment identifier -- even though it is within single-quotes as part of a literal string.
Is there a work-around for this? Like, for example, is there a way to turn off comments?