Re: How to escape apostrophes when apostrophes already used to escape something else - Mailing list pgsql-general

Stefan Schwarzer wrote:
> 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:
>
> $query = "SELECT
>             *
>         FROM
>             crosstab('SELECT
[...]
>                         (c.name = ''Cote
d'Ivoire'' )
>                     ORDER BY
>                         1,2;', 3) AS ct(name
varchar, y_1960 numeric)
>
> Now, "Cote d'Ivoire" needs to be escaped too. But how can I achieve
> this?

In your case, by using ''Cote d''''Ivoire''.

Yours,
Laurenz Albe