| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Running sql files |
| Date: | 2004-12-08 15:19:06 |
| Message-ID: | 809E1C3A-492C-11D9-AE7E-000A95B03262@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | FM | 2004-12-08 19:41:10 | postgresql 7.4.1 SRPM |
| Previous Message | Pascal Tufenkji | 2004-12-08 15:07:56 | Connections |