On 9/24/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
> --- Lonni J Friedman <netllama@gmail.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@gmail.com
LlamaLand https://netllama.linux-sxs.org