[GENERAL] How to escape apostrophes when apostrophes already used to escape something else

[Stefan Schwarzer]

Hi there,






$query = "SELECT
                        *
                FROM
                        crosstab('SELECT
                                                COALESCE(c.name, '''') AS name, 
                                                d.year_start AS year,
                                                d.value AS value        
                                        FROM
                                                co2_total_cdiac AS d
                                        RIGHT JOIN
                                                countries_view AS c ON c.id = 
d.id_country
                                        WHERE
                                                (d.year_start = 1960 ) AND
                                                (c.name = ''Cote d'Ivoire'' )
                                        ORDER BY
                                                1,2;', 3) AS ct(name varchar, 
y_1960 numeric)



Thanks for any hints.

Stef

probably not too complicated, but although googling my way through many pages, I don't find the solution. I have a query which uses already an apostrophe to escape something else: Now, "Cote d'Ivoire" needs to be escaped too. But how can I achieve this?

smime.p7s
Description: S/MIME cryptographic signature