Re: Copy entire file as one field

On Wed, 2002-12-04 at 12:16, Warren Massengill wrote:
> 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.

You *must* run your script this way:
$ ./merge4

And you did make sure that the script is executable, right?

> ------------------------------------
> #!/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.
> > >
> > > Somehow I failed to translate your instructions...
> > >
> > > -----------------------------------------------------
> > > #!/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.
> >--

--
+------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "they love our milk and honey, but preach about another |
| way of living" |
| Merle Haggard, "The Fighting Side Of Me" |
+------------------------------------------------------------+