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 по дате отправления: