Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C75A59FA103 for ; Tue, 5 Dec 2006 07:57:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 62958-09 for ; Tue, 5 Dec 2006 07:57:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id 19C5A9FA1DE for ; Tue, 5 Dec 2006 07:57:20 -0400 (AST) thread-index: AccYZIbUdqQcJpgTTkCvjMRGFg+NTA== Received: from [192.168.0.20] ([62.232.55.118]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 5 Dec 2006 06:57:23 -0500 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Subject: psql man page error? From: "Simon Riggs" To: Content-Type: text/plain; charset="iso-8859-1" Date: Tue, 05 Dec 2006 11:57:06 +0000 Message-ID: <1165319827.3839.146.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 05 Dec 2006 11:57:24.0062 (UTC) FILETIME=[86CB5FE0:01C71864] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/5 X-Sequence-Number: 3928 On the psql man page there is an example of how to perform multiple line psql script as part of the -c option description. The example given is echo "\x \\ select * from foo;" | psql which gives prompt> echo "\x \\ select * from foo;" | psql Expanded display is on. invalid command \ i.e. doesn't work on bash. With bash the command should be: echo -e "\x \n select * from foo;" | psql which gives prompt> echo -e "\x \n select * from foo;" | psql Expanded display is on. ERROR: relation "foo" does not exist Does this mean there are multiple forms of the echo command, or is this example just wrong? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com