Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Backslash Escape Sequences



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>



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group