Re: [GENERAL] building extension with large string inserts - Mailing list pgsql-general

From Tom van Tilburg
Subject Re: [GENERAL] building extension with large string inserts
Date
Msg-id CAP3PPDg9qjuy0aKi2wKC643=5xoEknqRsfif+T_kwKuX7MqqSA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] building extension with large string inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] building extension with large string inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] building extension with large string inserts  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
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@sss.pgh.pa.us> wrote:
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$ ...

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] building extension with large string inserts
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] building extension with large string inserts