Re: Running sql files

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Running sql files
Date: 2004-12-07 16:54:35
Message-ID: 20041207165435.1127.qmail@web50007.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

--- "Pradeepkumar, Pyatalo (IE10)"
<Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> escribió:
>
> 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.
>

$psql dbname < sqlfile > /dev/null

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2004-12-07 17:01:40 Re: Running sql files
Previous Message John Jensen 2004-12-07 15:31:08 Re: Backup is too slow