About not to see insertion result "INSERT 0 1"

Emi Lu <emilu@cs.concordia.ca> writes:

I do not want to see the 100,000 times "INSERT 0 1" displayed by
postgreSQL. Is there a way to hide the output "INSERT 0 1" generated by
postgresql ?

"psql -q" I think ... read the man page.

regards, tom lane

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 21 Nov 2005, Emi Lu wrote:

Is there a way to hide the output "INSERT 0 1" generated by postgresql ?

Use psql with -q.

Regards,
- --
Devrim GUNDUZ
Kivi Bili�im Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDgjKe4zE8DGqpiZARAtuDAJ0SBgG0F3NFnE7ViuL8Cfdo0UhyeQCfRDYz
INpBiSBxJf3/bdT60asEsb8=
=yJ8q
-----END PGP SIGNATURE-----

From pgsql-general-owner@postgresql.org Mon Nov 21 16:51:04 2005

X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id CCD9FDA015
for <pgsql-general-postgresql.org@localhost.postgresql.org>; Mon, 21 Nov 2005 16:51:00 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 60297-02
for <pgsql-general-postgresql.org@localhost.postgresql.org>;
Mon, 21 Nov 2005 20:51:00 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from perseverance.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94])
by svr1.postgresql.org (Postfix) with ESMTP id 091C5DA6B5
for <pgsql-general@postgresql.org>; Mon, 21 Nov 2005 16:50:56 -0400 (AST)
Received: from [132.205.44.35] (IDENT:emilu@curacao.cs.concordia.ca [132.205.44.35])
by perseverance.encs.concordia.ca (8.12.11/8.12.11) with ESMTP id jALKopIW013543;
Mon, 21 Nov 2005 15:50:51 -0500
Message-ID: <4382332A.2080007@cs.concordia.ca>
Date: Mon, 21 Nov 2005 15:50:50 -0500
From: Emi Lu <emilu@cs.concordia.ca>
Reply-To: emilu@cs.concordia.ca
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Devrim GUNDUZ <devrim@gunduz.org>
CC: pgsql-general@postgresql.org
Subject: Re: About not to see insertion result "INSERT 0 1"
References: <438230C6.4090707@cs.concordia.ca> <Pine.LNX.4.63.0511212247570.29688@mail.kivi.com.tr>
In-Reply-To: <Pine.LNX.4.63.0511212247570.29688@mail.kivi.com.tr>
Content-Type: text/plain; charset=ISO-8859-9; format=flowed
Content-Transfer-Encoding: 8bit
X-Scanned-By: MIMEDefang 2.43 on perseverance.encs.concordia.ca at 2005/11/21 15:50:51 EST
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[UPPERCASE_25_50=0]
X-Spam-Score: 0
X-Spam-Level:
X-Archive-Number: 200511/1028
X-Sequence-Number: 87171

Thanks a lot! That is exactly what I want.

- Emi

Emi Lu presumably uttered the following on 11/21/05 15:40:

Greetings,

I tried to run insert command from a .sql file. For example, in a.sql
file there are 100,000 lines like
insert into t1 values(... ...);
insert into t1 values(... ...);
insert into t1 values(... ...);
... ...

I do not want to see the 100,000 times "INSERT 0 1" displayed by
postgreSQL. Is there a way to hide the output "INSERT 0 1" generated by
postgresql ?

Thanks a lot!
Emi

Depending on how your application works, you would probably see a marked
speed increase by using the copy command rather than 100k insert lines.
The file could just be your Values(...) section which could then be
sucked in via copy.

Sven