| From: | "Warren Massengill" <warrenmassengill(at)hotmail(dot)com> |
|---|---|
| To: | Devinder(dot)Rajput(at)ipaper(dot)com |
| Cc: | olly(at)lfix(dot)co(dot)uk, pgsql-novice(at)postgresql(dot)org, ron(dot)l(dot)johnson(at)cox(dot)net |
| Subject: | Re: Copy entire file as one field |
| Date: | 2002-12-04 22:19:08 |
| Message-ID: | F68TojKI7U73G9yIpys000216e1@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
>From: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2002-12-05 00:22:02 | Re: Yet one more stupid question |
| Previous Message | Glenn English | 2002-12-04 22:08:47 | Re: installation.. |