[NOVICE] How to insert apostrophied names into postgres

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

---------------------------(end of broadcast)---------------------------

               http://www.postgresql.org/docs/faq Received on Mon Feb 18 19:00:43 2008