psql:ERROR: syntax error at or near "" LINE 1: 

Question

I'm executing fn_reset_eta_transactional_data(); function through linux machine. The function is for more then 100 schema. After running the script I'm getting

psql:/patha/query.sql:2: ERROR: syntax error at or near "" LINE 1: .

Please help.

Answer 1

I had the same problem: check the encoding of your script. Probably it UTF-8_BOM. So, I converted it to UTF-8 and error disappears. explanation