Postgres Pro
Downloads
Home   >   mailing lists

How to insert apostrophied names into postgres - Mailing list pgsql-novice

From richard terry
Subject How to insert apostrophied names into postgres
Date
Msg-id 200802191057.08677.rterry@gnumed.net
Whole thread Raw
Responses Re: How to insert apostrophied names into postgres  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Re: How to insert apostrophied names into postgres  ("Vyacheslav Kalinin" <vka@mgcp.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Mag Gam"
Date:
Subject: SQL question
Next
From: "Phillip Smith"
Date:
Subject: Re: How to insert apostrophied names into postgres