Re: Copy entire file as one field

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@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.
>--
>Oliver Elphick                                Oliver.Elphick@lfix.co.uk


_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail