Received: from cvis29.marconicomms.com (cvis29.marconicomms.com [195.99.244.61]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9VFqel75187 for ; Tue, 31 Oct 2000 10:52:40 -0500 (EST) (envelope-from Carl.Shelbourne@marconi.com) Received: from cvis01.gpt.co.uk (unverified) by cvis29.marconicomms.com (Content Technologies SMTPRS 4.1.5) with ESMTP id for ; Tue, 31 Oct 2000 13:22:20 +0000 Received: from marconicomms.com by cvis01.gpt.co.uk with SMTP (8.8.8+Sun/cvms-28) id NAA21187; Tue, 31 Oct 2000 13:22:19 GMT Received: by marconicomms.com(Lotus SMTP MTA v4.6.3 (733.2 10-16-1998)) id 80256989.00497224 ; Tue, 31 Oct 2000 13:22:13 +0000 X-Lotus-FromDomain: MCMAIN@MCEXT From: "Carl Shelbourne" To: pgsql-interfaces@postgresql.org Message-ID: <80256989.00496E96.00@marconicomms.com> Date: Tue, 31 Oct 2000 13:21:37 +0000 Subject: Re: how to get rid of "NOTICE"'s in psql? Mime-Version: 1.0 Content-type: multipart/mixed; Boundary="0__=mtRmyjDmT2p6NiWelfpemOiMOtce0DSXA7sjS62ElQ6fkFyQ0UWuZo8l" Content-Disposition: inline X-Archive-Number: 200010/24 X-Sequence-Number: 25 --0__=mtRmyjDmT2p6NiWelfpemOiMOtce0DSXA7sjS62ElQ6fkFyQ0UWuZo8l Content-type: text/plain; charset=us-ascii Content-Disposition: inline You could remove unwanted messages using: psql -q ....etc... 2>/dev/null Carl hubert depesz lubaczewski on 30/10/2000 10:53:15 Please respond to depesz@depesz.pl To: pgsql-interfaces@postgresql.org cc: (bcc: Carl Shelbourne/MAIN/MC1) Subject: [INTERFACES] how to get rid of "NOTICE"'s in psql? --0__=mtRmyjDmT2p6NiWelfpemOiMOtce0DSXA7sjS62ElQ6fkFyQ0UWuZo8l Content-type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-transfer-encoding: quoted-printable hi, i'm using psql while developing software. i have several .sql scripts which i run via \i script.sql most of them spill out a lot of "NOTICE" lines. like: psql:create.structure.sql:17: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'articles_pkey' for table 'articles' CREATE psql:create.structure.sql:23: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'kolejnosc_pkey' for table 'kolejnosc' psql:create.structure.sql:23: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE i want to make psql *not* show any NOTICES - just plain information like "CREATE", "INSERT", "COMMIT" and of course ERROR messages. is there any way (besides recompiling psql with simple "if") to do what i n= eed? depesz -- hubert depesz lubaczewski ------------------------------------------------------------------------ najwspanialsz=B1 rzecz=B1 jak=B1 da=B3o nam nowoczesne spo=B3ecze=F1st= wo, jest niesamowita wr=EAcz =B3atwo=B6=E6 unikania kontakt=F3w z nim ... --0__=mtRmyjDmT2p6NiWelfpemOiMOtce0DSXA7sjS62ElQ6fkFyQ0UWuZo8l--