Received: from MAIL01.stbernard.com (mail01.stbernard.com [64.154.93.162]) by postgresql.org (Postfix) with ESMTP id 1607847517F for ; Fri, 19 Apr 2002 14:32:07 -0400 (EDT) Received: by MAIL01.stbernard.com with Internet Mail Service (5.5.2653.19) id ; Fri, 19 Apr 2002 11:32:07 -0700 Message-ID: <7C760DAA511DC74B99E7D22189F786F101BF2036@MAIL01.stbernard.com> From: Jie Liang To: =?iso-8859-1?Q?=27St=E9phane_DEWITTE=27?= , pgsql-sql@postgresql.org Subject: Re: How to log outputs from pl/pgsql into a file ? Date: Fri, 19 Apr 2002 11:32:06 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Archive-Number: 200204/251 X-Sequence-Number: 7515 You might try: ./myshell 2>&1|tee test.log Jie Liang -----Original Message----- From: St=E9phane DEWITTE [mailto:stephane@smeso.fr] Sent: Friday, April 19, 2002 7:40 AM To: pgsql-sql@postgresql.org Subject: [SQL] How to log outputs from pl/pgsql into a file ? Hi everybody. I'm working un Linux SuSe7.0, Postgres 7.2 compiled from sources. I have a function in PL/pgSQL and I have to write some infos on screen. For that I use RAISE NOTICE ''Number %'',my_number; It works fine on screen, but now I want to log it on a different file each time (not the pog log). I've tried to make a shell (myshell) that calls the script psql mybase << EOF select my_func(); EOF and I make myshell > test.log I only have the retrun of my function, and not the 'raise' that only appears on screen. Idem if my shell is psql mybase << EOF \o test.log select my_func(); EOF and I have the same result. I guess it is possible ti have outputs written into a file (like "spool file" in SqlPlus for Oracle) but I didn't find anything on documentation for PL/pgSQL. Can I use raise notice for that ? And how ? And what else can I use ? Thanks a lot. Regards, Stephane. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org