How to suppress echo while executing batch files?

From: matthias(at)cmklein(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: How to suppress echo while executing batch files?
Date: 2004-11-17 01:17:16
Message-ID: E1CUERg-0001m7-00@www.strato-webmail.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have to execute fairly large batch files (200-300MB) with several million
INSERT commands.

When I do that from pgsql using the \i switch, I get the echo
INSERT 0 1

for every single insert statement of my batch file.

Since I assume that this slows down the whole process I would like to know
if there is a way to suppress that echo and only get error messages and
such?

Thanks

Matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2004-11-17 01:25:21 Re: Problems importing Unicode
Previous Message Michael Fuhr 2004-11-17 01:05:06 Re: ERROR: column "id" does not exist