Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id 264462E0054
	for <pgsql-docs-postgresql.org@developer.postgresql.org>;
	Thu,  1 May 2008 12:29:36 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 17883-06
	for <pgsql-docs-postgresql.org@developer.postgresql.org>;
	Thu,  1 May 2008 12:29:32 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from QMTA02.emeryville.ca.mail.comcast.net
	(qmta02.emeryville.ca.mail.comcast.net [76.96.30.24])
	by developer.postgresql.org (Postfix) with ESMTP id E71A02E0050
	for <pgsql-docs@postgresql.org>; Thu,  1 May 2008 12:29:32 -0300 (ADT)
Received: from OMTA07.emeryville.ca.mail.comcast.net ([76.96.30.59])
	by QMTA02.emeryville.ca.mail.comcast.net with comcast
	id L9nP1Z0011GXsucA20WC00; Thu, 01 May 2008 15:27:27 +0000
Received: from dhcp-142.subnet-212.amherst.edu ([148.85.212.142])
	by OMTA07.emeryville.ca.mail.comcast.net with comcast
	id LFVA1Z00D34ttPY8T00000; Thu, 01 May 2008 15:29:18 +0000
X-Authority-Analysis: v=1.0 c=1 a=epTmVMiNAAAA:8 a=XO9DgM-5XaP9WVR0UgAA:9
	a=BLLYiJGROGVcPU8cOlkA:7 a=6-aWcXYCLlp9wlAGcegaKk3uizsA:4
	a=WcGY3-TIXCwA:10
Message-Id: <3E797734-2E62-4E9D-955E-94D63EA114B7@amherst.edu>
From: Andy Anderson <aanderson@amherst.edu>
To: pgsql-docs@postgresql.org
In-Reply-To: <20080430220428.GA6149@alvh.no-ip.org>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v919.2)
Subject: Re: Backslash Escape Sequences
Date: Thu, 1 May 2008 11:29:09 -0400
References: <D08F79F6-8401-4503-BB09-56EAEF47714F@amherst.edu>
	<18414.1209565708@sss.pgh.pa.us>
	<F988E1CB-E8B2-47D0-BD50-1195E5675982@amherst.edu>
	<0108EC19-3397-4D79-8F05-F1AA1BDAE48B@amherst.edu>
	<20080430220428.GA6149@alvh.no-ip.org>
X-Mailer: Apple Mail (2.919.2)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200805/1
X-Sequence-Number: 4887

>> Andy Anderson wrote:
>>
>>> In any case, here's a contribution to the manual, a short table with
>>> this information, in a format that might help make the subject  
>>> clearer.
>> Modify at will!

> On Apr 30, 2008, at 6:04 PM, Alvaro Herrera wrote:
>> FWIW if you really want to make a contribution to the docs, please  
>> see
>> the SGML sources instead of the HTML output (which is machine- 
>> generated).

OK, then, I hope the following is accurate enough SGML to be more  
useful. Submitted here per the instructions on <http://www.postgresql.org/docs/8.3/interactive/bug-reporting.html 
 >.

-- Andy

********************************************************************

<table id="sql-backslash-table">
	<title>Backslash Escape Sequences</title>
	<tgroup cols="2">
		<thead>
			<row>
				<entry>Backslash Escape Sequence</>
				<entry>Interpretation</entry>
			</row>
		</thead>
		<tbody>
			<row>
				<entry><literal>\b</literal></entry>
				<entry>backspace</entry>
			</row>
			<row>
				<entry><literal>\f</literal></entry>
				<entry>form feed</entry>
			</row>
			<row>
				<entry><literal>\n</literal></entry>
				<entry>newline</entry>
			</row>
			<row>
				<entry><literal>\r</literal></entry>
				<entry>carriage return</entry>
			</row>
			<row>
				<entry><literal>\t</literal></entry>
				<entry>tab</entry>
			</row>
			<row>
				<entry>
					<literallayout>
						<literal>\<replaceable>o</replaceable></literal>
						<literal>\<replaceable>oo</replaceable></literal>
						<literal>\<replaceable>ooo</replaceable></literal>
						(<replaceable>o</replaceable> = 0 - 7)
					</literallayout>
				</entry>
				<entry>octal byte value</entry>
			</row>
			<row>
				<entry>
					<literallayout>
						<literal>\x<replaceable>h</replaceable></literal>
						<literal>\x<replaceable>hh</replaceable></literal>
						(<replaceable>h</replaceable> = 0 - F)
					</literallayout>
				</entry>
				<entry>hexadecimal byte value</entry>
			</row>
			<row>
				<entry>
					<literallayout>
						<literal>\<replaceable>a</replaceable></literal>
						(<replaceable>a</replaceable> = any other character than the  
above,
						e.g. <literal>\</literal> and <literal>'</literal>.)
					</literallayout>
				</entry>
				<entry><replaceable>a</replaceable></entry>
			</row>
		</tbody>
     </tgroup>
</table>