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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
