Обсуждение: better way

I have a bunch of insert into statements just wondering if anyone knows
of more succinct way of doing multiple
Insert Into mytable(col1,col2,co3 etc) values ('one','two','three');
without repeating the Insert Into ?
thanks
Lori

if your output is from a query do

insert into mytable(col1, col2, col3)
    (select col_a, col_b, col_c from othertable);

or

use the copy command

ex.
copy mytable from 'filepath/filename' using delimiters '\t';

you can also use stdin as the input path.

On Friday 27 May 2005 02:28 pm, Lori wrote:
> I have a bunch of insert into statements just wondering if anyone knows
> of more succinct way of doing multiple
> Insert Into mytable(col1,col2,co3 etc) values ('one','two','three');
> without repeating the Insert Into ?
> thanks
> Lori
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)