Informix to PG: fail to convert double-quote used for literal values

[strk]

In informix you can use double-quotes to wrap literal values containing single quotes, but in PostgreSQL double-quotes are only for identifiers, never for literal. In PostgreSQL you can use dollar-quoting if you want to include single-ticks in a string, like:

SELECT $$I can use ' here$$