Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] string containing (') - Mailing list pgsql-sql

From Brian Baquiran
Subject Re: [SQL] string containing (')
Date
Msg-id 36F3C76D.42F9EAFD@evoserve.com
Whole thread Raw
In response to Re: [SQL] string containing (')  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [SQL] string containing (')
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Eugenia Bulakh
Date:
Subject: [SQL] Restore deleted records
Next
From: "Robert McArthur"
Date:
Subject: ...