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@localhost pg]$ merge
> merge: not enough arguments
> merge: usage: merge [-AeEpqxX3] [-L lab [-L lab [-L lab]]] file1 file2 file3
> merge aborted
> --------------------------------------
> [kelly@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.l.johnson@cox.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"                |
+------------------------------------------------------------+