Re: Running sql files

Hi all,

Thanks a lot for all your valuable inputs. I tried "\set QUIET" and "\unset
QUIET" arount certain parts of the file. It works fine with INSERT COMMANDS.
But incase of creating tables, it still prints NOTICE and ERROR messages on
the screen...how do I restrict that.

Regs,
Pradeep

-----Original Message-----
From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
Sent: Tuesday, December 07, 2004 10:32 PM
To: Pradeepkumar, Pyatalo (IE10)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Running sql files

On Tue, Dec 07, 2004 at 04:55:24AM -0700, Pradeepkumar, Pyatalo (IE10)
wrote:

> $psql dbname < sqlfile
> The results of the command are displayed on to the screen. In one
> file I am trying to populate a table with values ( There are more than
> 5000 tuples to be inserted).
> When I run this command, it displays the results on to the screen
> which I don't want to do.

As someone else suggested, you could redirect the script's output to
/dev/null. You could also use psql's -q ("quiet") option or surround
certain parts of the file with "\set QUIET" and "\unset QUIET".

COPY is quieter and more efficient than INSERT, so if you're using INSERT
then you could replace it with the appropriate COPY statement.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/