A while back, I was fixing up procedures in PL/pgSQL for a company. The procedures had to be rewritten, and they all sort of looked like this: create function.

A while back, I was fixing up procedures in PL/pgSQL for a company. The procedures had to be rewritten, and they all sort of looked like this: create function... """ declare some string "'"this string"'" int """ end; The cross-database client didn't support or comprehend $$ escaping, so the people who wrote everything had no choice but the write with loads of quotes everywhere. I didn't realize this, so I passed some code back to them and they couldn't run it at all. The client-specific programs are all optimized to the RDMS you are using, so I never was able get on board with these products.