Postgres Pro
Downloads
Home   >   mailing lists

Re: Running sql files - Mailing list pgsql-admin

From Kevin Izzet
Subject Re: Running sql files
Date
Msg-id OF9018C6D8.B88F6643-ON80256F63.0041F817-80256F63.004215B9@nsc.com
Whole thread Raw
In response to Running sql files  ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>)
List pgsql-admin
Tree view

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 by date:

Previous
From: "Pradeepkumar, Pyatalo (IE10)"
Date:
Subject: Running sql files
Next
From: "Spiegelberg, Greg"
Date:
Subject: Re: Backup is too slow