Re: Copy entire file as one field

>From: "Devinder K Rajput" <Devinder(dot)Rajput(at)ipaper(dot)com>
>
>What error msg do you get after you change the name of the script?
>
>Devinder

Sorry, I should have said that the revised script (merge4) error message was
shown below...
--------------------------------------
[kelly(at)localhost pg]$ merge4
bash: merge4: command not found
--------------------------------------
Thanks,
Warren
>
>The revised version has the same result. If I change the name of the script
>(another poster suggested avoiding the reserved word 'merge') there is a
>different error message.
>
>Thanks,
>Warren
>
>------------------------------------
>#!/bin/bash
>
>for f in `ls /home/kelly/message/*`
>do
> psql -d pg -c "INSERT INTO mail (message)
> VALUES ('`cat $f`')"
>done
>
>-------------------------------------
>[kelly(at)localhost pg]$ merge
>merge: not enough arguments
>merge: usage: merge [-AeEpqxX3] [-L lab [-L lab [-L lab]]] file1 file2
>file3
>merge aborted
>--------------------------------------
>[kelly(at)localhost pg]$ merge4
>bash: merge4: command not found
>--------------------------------------
> >
> >On Tue, 2002-12-03 at 19:48, Warren Massengill wrote:
> > > My database is pg, the table is mail.
> > > The small text files are in /home/kelly/message/.
> > > The bash shell script is merge.
> > > -----------------------------------------------------
> > > #!/bin/bash
> > >
> > > for f in `ls /home/kelly/message*`
> > ^^^^^^
> > message/*
> >
> > > do
> > > psql -d pg -c "INSERT INTO mail (message)
> > > VALUES ('`cat $f`')"
> > > done
> >
> >Your files are in that directory, so the wild card must be too.
> >--
> >Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail