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