Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 91FDE9F9F46 for ; Wed, 6 Dec 2006 11:47:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 36740-07 for ; Wed, 6 Dec 2006 11:46:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 266D29FA17D for ; Wed, 6 Dec 2006 11:46:59 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kB6Fkur15136; Wed, 6 Dec 2006 10:46:56 -0500 (EST) From: Bruce Momjian Message-Id: <200612061546.kB6Fkur15136@momjian.us> Subject: Re: psql man page error? In-Reply-To: <26312.1165419725@sss.pgh.pa.us> To: Tom Lane Date: Wed, 6 Dec 2006 10:46:56 -0500 (EST) CC: Peter Eisentraut , pgsql-docs@postgresql.org, Simon Riggs X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="ELM1165420016-16504-2_" Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/23 X-Sequence-Number: 3946 --ELM1165420016-16504-2_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" Tom Lane wrote: > Bruce Momjian writes: > > ! pipe the string into psql, like > > ! this: echo "\x \\ SELECT * FROM foo;" | psql. > > This should probably use single quotes not double, hm? Yep, done. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + --ELM1165420016-16504-2_ Content-Transfer-Encoding: 7bit Content-Type: text/x-diff Content-Disposition: inline; filename="/rtmp/diff" Index: doc/src/sgml/ref/psql-ref.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ref/psql-ref.sgml,v retrieving revision 1.177 diff -c -c -r1.177 psql-ref.sgml *** doc/src/sgml/ref/psql-ref.sgml 6 Dec 2006 15:40:11 -0000 1.177 --- doc/src/sgml/ref/psql-ref.sgml 6 Dec 2006 15:46:30 -0000 *************** *** 89,95 **** SQL and psql meta-commands with this option. To achieve that, you could pipe the string into psql, like ! this: echo "\x \\ SELECT * FROM foo;" | psql. (\\ is the separator meta-command.) --- 89,95 ---- SQL and psql meta-commands with this option. To achieve that, you could pipe the string into psql, like ! this: echo '\x \\ SELECT * FROM foo;' | psql. (\\ is the separator meta-command.) --ELM1165420016-16504-2_--