Thanks a lot, I use the '' approach, works for my case.
Regards
Am 02.03.2012 um 10:14 schrieb Pavel Stehule:
> Hello
>
> you cannot use a \ escaping when you have standard_conforming_strings enabled.
>
> There are four ways:
>
> first - use a usual way for using quotes - use a doubling sin
Hello
you cannot use a \ escaping when you have standard_conforming_strings enabled.
There are four ways:
first - use a usual way for using quotes - use a doubling single quotes
postgres=# select 'Peter''s toy';
?column?
─
Peter's toy
(1 row)
or you can use a own string delimite
Hi,
I just migrated from mysql and am running into an issue I found no solution for
when researching. Using the web interface I can insert values that contain
single-quotes. But using the CLI I found no way to select or insert single
quotes:
PetWork=# select * from persons where firstname='\'P
