Skip site navigation (1) Skip section navigation (2)

Re: Running sql files

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 (view raw or flat)
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 

pgsql-admin by date

Next:From: rrayDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group