Re: building extension with large string inserts

I think I misunderstand. How would that help my insert statement?
You would get INSERT INTO mytable VALUES ($ javascript with a lot of
unescaped characters like /n " // etc. $);

and: Am I correct that INSERTS are the way to go in extensions?

Best,
Tom vT.

On Wed, Jul 5, 2017 at 4:57 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Tom van Tilburg <tom(dot)van(dot)tilburg(at)gmail(dot)com> writes:
> > I am trying to build an extension where there is the need to insert large
> > strings consisting of javascript code.
> > ...
> > What would be a proper way to get this code into a table via an
> extension?
> > I've been working on generating INSERT statements for the extension's sql
> > file but it seems a tedious job to escape the code myself.
>
> Can't you use a dollar-quoted string? You just need to pick a delimiter
> that doesn't appear anywhere in the javascript, say $JaVaScRiPt$ ...
>
> regards, tom lane
>