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

On 9/24/07, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
>
> --- Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
>
> > > (e.g. ...-c"insert into table (info) values('`sed "s/'/''/g"
> > > file.txt`')" )
> > >
>
> if single quotes were your problem, then maybe you could use Postgresql's dollar sign quoting.
>
> you could replace the ' with $myquote$.

Actually the issue here is that i'm inserting build log snippets, so
I'm never going to be 100% what will appear. Single quotes were
definitely the issue the first time I hit this. Are there any other
characters that are verboten, or just single quotes?

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