This pattern the above found many times. Please guide me through!!!
IIRC, people have been working around this by setting standard_conforming_strings to "off". It really ought to be fixed in a principled way, though -- the real issue here is that dbt2 has severe bit-rot.
Sorry for so asking so late. I thought the error is resolved.
I changed standard_conforming_strings to "off" in postgresql.conf. and then I run dbt2-pgsql-build-db -w 1 script again.
But, I am still facing the same error. Please tel me what else I can do to resolve the issue.