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 <t...@sss.pgh.pa.us> wrote: > Tom van Tilburg <tom.van.tilb...@gmail.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 >