How to insert apostrophied names into postgres

[richard terry <rterry(at)gnumed(dot)net>]

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'); 

and bombs.

Any suggestions appreciated.

Richard