Re: [SQL] string containing (')

From: Brian Baquiran <brianb(at)evoserve(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] string containing (')
Date: 1999-03-20 16:06:05
Message-ID: 36F3C76D.42F9EAFD@evoserve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruce Momjian wrote:
>
> > HI!
> > Can anyone help,
> > I want to store a string into a relation that might contain an apostrophe
> > ('). Is there anyway around this or can I not store such strings.
> > Thanks for your help
>
> '\''

I've always thought the proper way was to use 2 quotes ('').

Brian

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert McArthur 1999-03-20 22:40:03
Previous Message Eugenia Bulakh 1999-03-20 14:44:47 [SQL] Restore deleted records