Re: Running sql files - Mailing list pgsql-admin

From John DeSoi
Subject Re: Running sql files
Date
Msg-id 809E1C3A-492C-11D9-AE7E-000A95B03262@pgedit.com
Whole thread Raw
In response to Running sql files  ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>)
List pgsql-admin
On Dec 7, 2004, at 6:55 AM, Pradeepkumar, Pyatalo (IE10) wrote:

> I just wanted to know how to disable the results being displayed on
> the screen.
> When I try the following command -
> $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.
> Could anyone help me in this.

You can also send the output to a file with the -o option. That way,
you can review the results if any problems arise.

$psql -o myoutput dbname < sqlfile

See the psql section in the manual for more options to control the
output.

Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL



pgsql-admin by date:

Previous
From: Bjoern Metzdorf
Date:
Subject: statistics buffer is full
Next
From: Michael Fuhr
Date:
Subject: Re: Running sql files