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

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