You could try running the command like this
$psql dbname < sqlfile > /dev/null
I believe this should work fine
Database / Unix / Linux Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
Sent by: pgsql-admin-owner(at)postgresql(dot)org
Subject: [ADMIN] Running sql files
I just wanted to know how to disable the results being displayed on the
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.
Thanks in advance.
pgsql-admin by date
|Next:||From: rray||Date: 2004-12-07 14:32:22|
|Subject: Login with blank password|
|Previous:||From: Pradeepkumar, Pyatalo (IE10)||Date: 2004-12-07 11:55:24|
|Subject: Running sql files|