From: | "Kevin Izzet" <Kevin(dot)Izzet(at)nsc(dot)com> |
---|---|
To: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-admin-owner(at)postgresql(dot)org |
Subject: | Re: Running sql files |
Date: | 2004-12-07 12:01:48 |
Message-ID: | OF9018C6D8.B88F6643-ON80256F63.0041F817-80256F63.004215B9@nsc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
You could try running the command like this
$psql dbname < sqlfile > /dev/null
I believe this should work fine
Regards
Kevin Izzet
Database / Unix / Linux Administrator
Tel: (Code)+44(0)1475 655606
Fax: (Code)+44(0)1475 637755
Email: Kevin(dot)Izzet(at)nsc(dot)com
"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
Sent by: pgsql-admin-owner(at)postgresql(dot)org
07/12/2004 11:55
To: pgsql-admin(at)postgresql(dot)org
cc:
Subject: [ADMIN] Running sql files
Hi,
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.
Thanks in advance.
Regards,
Pradeep
From | Date | Subject | |
---|---|---|---|
Next Message | rray | 2004-12-07 14:32:22 | Login with blank password |
Previous Message | Pradeepkumar, Pyatalo (IE10) | 2004-12-07 11:55:24 | Running sql files |