Re: [NOVICE] 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               
http://archives.postgresql.org