Re: Copy entire file as one field

Поиск
Список
Период
Сортировка
От Warren Massengill
Тема Re: Copy entire file as one field
Дата
Msg-id F68TojKI7U73G9yIpys000216e1@hotmail.com
обсуждение исходный текст
Ответ на Copy entire file as one field  ("Warren Massengill" <warrenmassengill@hotmail.com>)
Список pgsql-novice






>From: "Devinder K Rajput" <Devinder.Rajput@ipaper.com>
>Date: Wed, 4 Dec 2002 14:30:18 -0600
>
>
>from the error messages it seems that it can not the bash shell.  One thing
>to try is
>$ which bash
>
>and see if returns with the location or  just try running the following one
>liner  from the command line:
>
>for f in `ls /home/kelly/message/*`;do psql -d pg -c "INSERT INTO mail
>(message) VALUES ('`cat $f`')"; done

Ahhhh, it works! I'll have to find out what's wrong with my shell scripting
but using this command line works for now.

Thanks to all.
Warren
>
>Devinder Rajput
>Stores Division Corporate Offices
>Chicago, IL
>(773) 442-6474

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus


В списке pgsql-novice по дате отправления:

Предыдущее
От: Glenn English
Дата:
Сообщение: Re: installation..
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Yet one more stupid question