Re: inserting/updating a field with the contents of a text file

On 9/24/07, George Pavlov <gpavlov(at)mynewplace(dot)com> wrote:
> > psql -q -d database0 -h server -c "UPDATE table set info='`cat
> > /tmp/file.txt`' where id=3;"
> >
> > and this almost works. The problem is that whenever there are
> > carriage returns in file.txt, the rest of the file contents never get
> > inserted (i only get the first line).
>
> Not sure what's inside your file, but the CRs are not your problem. What
> you do have to be concerned about escaping are any single quotes. You
> can do that with whatever your favorite search and replace utility is
> (e.g. ...-c"insert into table (info) values('`sed "s/'/''/g"
> file.txt`')" )
>
> Just so you know I am not making it up on the CRs here's an example:

Thanks, that appears to have been the issue.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand https://netllama.linux-sxs.org