From: | Sven Willenberger <sven(at)dmv(dot)com> |
---|---|
To: | emilu(at)cs(dot)concordia(dot)ca |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: About not to see insertion result "INSERT 0 1" |
Date: | 2005-11-21 22:13:28 |
Message-ID: | 43824688.2060206@dmv.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Emi Lu presumably uttered the following on 11/21/05 15:40:
> Greetings,
>
> I tried to run insert command from a .sql file. For example, in a.sql
> file there are 100,000 lines like
> insert into t1 values(... ...);
> insert into t1 values(... ...);
> insert into t1 values(... ...);
> ... ...
>
> I do not want to see the 100,000 times "INSERT 0 1" displayed by
> postgreSQL. Is there a way to hide the output "INSERT 0 1" generated by
> postgresql ?
>
> Thanks a lot!
> Emi
>
Depending on how your application works, you would probably see a marked
speed increase by using the copy command rather than 100k insert lines.
The file could just be your Values(...) section which could then be
sucked in via copy.
Sven
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Terenzio | 2005-11-21 23:12:22 | Timestamp with Timezone |
Previous Message | Bill Moseley | 2005-11-21 22:06:35 | Re: SQL Help: Multiple LEFT OUTER JOINs |