Re: Unwanted nested dollar-quoted constants

Bernard Henry Voynet <bhv(at)quebecemail(dot)com> writes:
> All the text fields are specified using the dollar-quoted string constant form that.

This is your mistake to start with. You can not simply stick a couple
of dollar signs around a random string and expect to have a valid
literal, any more than you can stick a couple of quote marks around it
and expect to have a valid literal. Dollar-quoting is not a magic
bullet that will let you forget about escaping data.

I would recommend going back to regular quoted literals and making sure
you double any quotes or backslashes in the data. It's possible to
develop appropriate code for dollar-quoting random text, but it's a lot
harder than it is to escape the data in the old style.

regards, tom lane