Re: 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/