[Gambas-user] putting name with apostrophe into postgres via gambas

[Arief Bayu Purwanto]

On Feb 19, 2008 7:11 AM, richard terry <rterry at ...1822...> wrote:

> eg Peter's
>
> if one passes the name to an sql in code it ends up looking like:
>
> insert into whatevertable (name) values('Peter's');

Taken from this archive[1], you can use :

'foo''s bar'
'foo\'s bar'
$$foo's bar$$

[1]http://archives.postgresql.org/pgsql-general/2005-11/msg01288.php
-- 
Arief Bayu Purwanto
About : http://about.freelancer.web.id/
Blog : http://bayu.freelancer.web.id/