Re: the use of $$string$$

On Friday, November 04, 2011 07:38:29 am John Fabiani wrote:
> Hi,
> I just discovered that I can use $$string$$ to account for the problem of
> single quotes in the string (or other strange char's).  However, I noticed
> that the table field contained E'string'.  I actually tried to find info on
> this but I did not find anything.
> 
> Could someone explain what it means or better provide a web link for me to
> discover the info.
> 
> Thanks in advance,
> Johnf


Thank you both for the quick replies and the links.  

What I still do not understand (I'm a little slow) is the fact that pgadmin3 
showed the data as E'string'.  So I'm wondering if the data is now different 
in the sense that I need use the 'E' in the field.

For example I have the last name of O'Reilly
the field lname now appears to contain E'O'Reilly'

So will the normal select statements work;

Select * from table where lname = 'O'' Reilly'
Select * from table where lname like 'O%'

or will I need to know the data contains the "E"  and add the 'E' to the sql 
statements?

Thanks
Johnf