X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E616BD1B53C for ; Fri, 19 Sep 2003 18:47:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 09360-06 for ; Fri, 19 Sep 2003 15:47:18 -0300 (ADT) Received: from web21402.mail.yahoo.com (web21402.mail.yahoo.com [216.136.232.72]) by svr1.postgresql.org (Postfix) with SMTP id 5D3D7D1B4EA for ; Fri, 19 Sep 2003 15:47:16 -0300 (ADT) Message-ID: <20030919184716.51818.qmail@web21402.mail.yahoo.com> Received: from [64.81.205.234] by web21402.mail.yahoo.com via HTTP; Fri, 19 Sep 2003 11:47:16 PDT Date: Fri, 19 Sep 2003 11:47:16 -0700 (PDT) From: ow Subject: psql output and password Qs To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/207 X-Sequence-Number: 15185 Hi, 1) When psql is run from a script, how would one save *all* output generated by psql (including errors, info messages, etc) in to a file?. I tried redirecting output with ">" but that did not save error/confirmation messages. 2) When psql is run from a script, how would one pass a password to psql? Thanks __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com