From: Tom Lane <tgl@sss.pgh.pa.us>
To: John Fabiani <johnf@jfcomputer.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: the use of $$string$$
Date: Fri, 04 Nov 2011 10:57:24 -0400
Message-ID: <7743.1320418644@sss.pgh.pa.us> (raw)
In-Reply-To: <201111040738.29303.johnf@jfcomputer.com>
References: <201111040738.29303.johnf@jfcomputer.com>
John Fabiani <johnf@jfcomputer.com> writes:
> 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.
http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html
See "4.1.2.4. Dollar-quoted String Constants", about halfway down the
page. You might care to read the rest of 4.1.2 while at it.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, johnf@jfcomputer.com
Subject: Re: the use of $$string$$
In-Reply-To: <7743.1320418644@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox