better way

Поиск
Список
Период
Сортировка
Искать

better way

От:
Lori <lorid@dri.edu>
Дата:
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

Re: better way

От:
"Mark R. Dingee" <mark.dingee@cox.net>
Дата:
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)
FAQ