On Wed, Nov 17, 2004 at 02:17:16AM +0100, matthias@xxxxxxxxxx wrote: > I have to execute fairly large batch files (200-300MB) with several million > INSERT commands. Can these files be rewritten to use COPY instead of INSERT? Performance might improve. > 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? \set QUIET -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
