Tom van Tilburg <tom.van.tilburg@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$ ...