How to insert apostrophied names into postgres

From: richard terry <rterry(at)gnumed(dot)net>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: How to insert apostrophied names into postgres
Date: 2008-02-18 23:57:08
Message-ID: 200802191057.08677.rterry@gnumed.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Phillip Smith 2008-02-19 00:20:02 Re: How to insert apostrophied names into postgres
Previous Message Mag Gam 2008-02-18 23:36:52 SQL question