Re: Running sql files
| От | Kevin Izzet |
|---|---|
| Тема | Re: Running sql files |
| Дата | |
| Msg-id | OF9018C6D8.B88F6643-ON80256F63.0041F817-80256F63.004215B9@nsc.com обсуждение исходный текст |
| Ответ на | Running sql files ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>) |
| Список | 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.Izzet@nsc.com
| "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com> Sent by: pgsql-admin-owner@postgresql.org 07/12/2004 11:55 | To: pgsql-admin@postgresql.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
В списке pgsql-admin по дате отправления: