Re: [GENERAL] Problem with apostrophe
Byron Nikolaidis <byronn@insightdist.com>
From: Byron Nikolaidis <byronn@insightdist.com>
To: eric@gateway.ctlno.com
Cc: pgsql-general@postgreSQL.org
Date: 1998-06-17T19:54:51Z
Lists: pgsql-general
Just escape the apostrophe with a backslash. Byron eric@gateway.ctlno.com wrote: > Is there any way of having an apostrophe in a data field? > It is a problem because the apostrophe is the same character as the single > quote, so the database gets a parser error when a name such as "O'Brian" > is entered. > > There must be a work-around, but I can not find any solution. > > thank you for your help